January 15, 2012 at 12:43 am
We could execute this stored proc on the publisher and disable publishing.
EXEC sp_replicationdboption @dbname = N'Publication Db Name', @optname = N'publish', @value = N'false'
This procedure drops the replication system tables etc. thereby removing the publication.
Are there any commands that are available which would help to momentarily disable publishing but would help to republish the same database again without going through the pain of configuring replication all over again.
Like example,
EXEC sp_replicationdboption @dbname = N'Publication Db Name', @optname = N'publish', @value = N'true'
Running this SP with true option has no meaning after running this SP with false option as publication gets disbabled. Would appreciate any inputs.
M&M
January 15, 2012 at 4:08 pm
You could have replication scripted out and use sp_droparticle to drop the articles rather than unpublish the entire database.
January 15, 2012 at 8:12 pm
Thank you Nicholas
M&M
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply