Dropping linked servers

• extremenovice

  SSCrazy

  Points: 2118

  More actions

  January 6, 2011 at 5:16 am

  #231833

  Hi All, help would be appreciated on this one.

  I have a linked server from Server A to Server B and i want to delete the link between them both. When i try to delete it on Server A because i already have on Server B, but the following error appears. I know that there is no replication setup from either of these two servers, so why and how can this error appear??

  Thanks in advance.

  Error Message:Drop failed for LinkedServer 'SVRCMSKP4J'. (Microsoft.SqlServer.Smo)

  Cannot drop server 'SVRCMSKP4J' because it is used as a Subscriber to remote Publisher 'SVRFMSKP4J' in replication. (Microsoft SQL Server, Error: 20584)

• Lempster

  SSCoach

  Points: 15651

  More actions

  January 6, 2011 at 5:24 am

  #1270021

  If you expand the Local Subscriptions node under the Replication node on your Server A, do you see anything?

  Try executing sp_removedbreplication on Server A.

• extremenovice

  SSCrazy

  Points: 2118

  More actions

  January 6, 2011 at 5:33 am

  #1270024

  Thanks for your reply. I have done both, checked the subscritpions and publishers on both server A & B and neither of them have replication setup. I have run the sp you provided and that stated success, but im still unable to delete the linked server.

  Thanks for your help.