August 23, 2005 at 2:54 pm
Hi guys,
My replication setup is as follows:
The publisher (SQLSPIKE) is having the publication PULLED from it by the subscriber (SQLREPORTS). We had to make a change to the publication (removing a table that was causing all sorts of hassle) and do the following:
Dropped the subscription
Removed the offending article
Readded the subscription
Re-ran the snapshot
The snapshot ran fine, but when we kicked off the replication task itself we got the message:
Cannot drop view <BLAH> as it is being used by replication.
Both servers are Windows 2003 and running SQL Server 2000 sp3a.
Any help would be gratefully appreciated!
Iain - New to All This
August 24, 2005 at 4:54 am
this is abnormal.
What is the name of the view?
Can you try to run sp_MSunmarkreplinfo against it?
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
August 26, 2005 at 3:01 am
Hi,
Thanks for the help, but this appears to have resolved itself. *shrugs* One of those things I guess.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply