Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication failure . Help required .

Author  Topic 

admin001
Posting Yak Master

166 Posts

Posted - 2002-09-25 : 03:59:41
Hello ,

I have SQL 7.0 publication and it has SQL 6.5 subscribers . However during the replication , one subscriber is displaying error that

'Procedure usp_replcontrol could not be deleted and its in use ' and the replication fails .

The insert command is replaced by ' call usp_replcontrol ' stored procedure at the source SQL 7.0 server and the snapshot property is
' DROP the existing table and re-create it '.

I tried removing the subscriber and adding again , but that did not help .

Any solution to this problem ??

Thanks .

   

- Advertisement -