Wednesday, March 21, 2012

DB Shared after Replication-How?

Hi,
I tried to implement Snapshot replication and collected all the test
results. Finally dropped all the replication stuff from server,but the host
DB is still showing as "Shared" and i need help to remove this.Not sure how
to proceed. Any help will be great.
Thanks,
Shyam
Please try this:
USE master
EXEC sp_dboption 'yourdatabasename', 'published', 'FALSE'
HTH,
Paul Ibison

No comments:

Post a Comment