6.5 replication questions HELP ME!!!

[Susan]

We have a subscription that is failing due to '24000[Microsoft][ODBC SQL Server Driver]Invalid cursor state'

My thought was to unsubscribe and subscribe again synching the tables.
HOWEVER, I have been told that I cannot drop the table in question
and have been asked to truncate instead.
There are over 25 subscriptions to this article, so I am unable to
modify the actual article.
I started playing in the pubs database to see if I can do it before
I messed with production...

I thought if I just change the .sch script located in the repldata direcotry to truncate table instead of create table, that would be it...
However the drop table command seems to come before it even reaches
that script, cause the error I get now is 'S0002[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot truncate table 'authors', because this table does not exist in database 'pubs'.'

My question is - when and where does the "drop table" command get executed
and can I modify it without effecting the other subscriptions?

I checked the sysarticles and the column that says del_cmd is Null....

PLEASE HELP....

[susan]

Found a solution to my own problem, through Data Synchronization manually applied by operator.

Thanks
Susan


------------
Susan at 3/20/01 12:07:33 PM


We have a subscription that is failing due to '24000[Microsoft][ODBC SQL Server Driver]Invalid cursor state'

My thought was to unsubscribe and subscribe again synching the tables.
HOWEVER, I have been told that I cannot drop the table in question
and have been asked to truncate instead.
There are over 25 subscriptions to this article, so I am unable to
modify the actual article.
I started playing in the pubs database to see if I can do it before
I messed with production...

I thought if I just change the .sch script located in the repldata direcotry to truncate table instead of create table, that would be it...
However the drop table command seems to come before it even reaches
that script, cause the error I get now is 'S0002[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot truncate table 'authors', because this table does not exist in database 'pubs'.'

My question is - when and where does the "drop table" command get executed
and can I modify it without effecting the other subscriptions?

I checked the sysarticles and the column that says del_cmd is Null....

PLEASE HELP....