October 28, 2010 at 1:19 pm
Hi All,
I have done snapshot replication setup and now I am deleting the setup. After deleting the subscriber,publisher, I am trying to remove distributor for which i am getting the below error.
-------------------------------------
Drop failed for LinkedServer 'repl_distributor'. (Microsoft.sqlserver.smo)
Can not drop server 'repl_distributor' because it is used as a Distributor in replication. (Microsoft SQL Server, Error 20581)
-------------------------
I have also deleted the linked server but still getting the above error.
Please help me to resolve the issue.
Thank you.
October 29, 2010 at 9:15 am
First run sp_dropsubscriber in the publisher database and then run sp_dropdistributor at the distributor.
You can find the option for running these commands in Books On Line.
-Roy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply