I am having a problem stopping replication on SQLServer 2008 R2. When I select "Disable Publishing and Distribution" from the Replication context menu of SQL Server Management Studio, my system appears to hang. After shutting down SSMS and restarting
it, "Disable Publishing and Distribution" works correctly. I have tracked this down to the call:
exec sp_replicationdboption @dbname = N'active_test', @optname = N'publish', @value = N'false'
My test setup:
Windows Server 2008 vm hosted by VMWare
SQL Server 2008 R2
Transactional replication with the publisher, distributor and subscriber all on the same database server.
View Complete Post