Sunday, March 25, 2012

Cannot DROP PROCEDURE 'duplicate incombolists' because it is being referenced by object

How to resolve this problem
Cannot DROP PROCEDURE 'duplicate _in_combolists' because it is being
referenced by object 'combolists_unique'.
Thanks in advance
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Presumably htis is on application of the snapshot? Before being created in
the initialization, objects are dropped. It looks like you have a dependency
which is preventing this being achieved. Please use sp_depends with
'duplicate _in_combolists' to investigate what is preventing the drop.
Removing the dependency should allow the initialization to proceed.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment