Post reply

Dropping linked servers

  • 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)

  • 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.

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply