Hi,
I removed a publication using the enterprise manager, and it has gone from
the publications views, but i can make the db ofline, because it reports it
is still published.
What can i do to tidy this up?
Thanks
Duncan
Duncan,
try
USE master
EXEC sp_dboption 'your db name', 'published', 'FALSE'
EXEC sp_dboption 'your db name', 'merge publish', 'FALSE'
HTH,
Paul Ibison
Showing posts with label fromthe. Show all posts
Showing posts with label fromthe. Show all posts
Monday, March 19, 2012
deleting a publication
Labels:
database,
deleting,
enterprise,
fromthe,
manager,
microsoft,
mysql,
ofline,
oracle,
publication,
publications,
reports,
server,
sql,
views
Subscribe to:
Posts (Atom)