Tuesday, December 28, 2010

How to Remove Replication from server / Cannot drop server ‘repl_distributor’ because it is used as a Distributor in replication

I was having problem to remove Replication from server after removing the replication from the db using
EXEC sp_removedbreplication 'DBName';

then after getting some research i got how to do this, here is the procedure

EXEC master.dbo.sp_serveroption @server=N'abcserver', @optname=N'dist', @optvalue=N'false'

use sp_helpserver to get servers.

or use this command
EXEC sp_dropdistributor @no_checks = 1, @ignore_distributor = 1

No comments:

Post a Comment