removing linkedservers

• SQLisAwe5oMe

  SSChampion

  Points: 14052

  More actions

  July 12, 2013 at 9:13 pm

  #277412

  Hi all,

  I have to remove some linkedservers which connects to oracle and pull data and I need to remove some of them. What is the proper way to remove these?

  Do I need to check before I drop or delete them? Please advise.

  Thanks,

  SueTons.

  Regards,
  SQLisAwe5oMe.

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  July 13, 2013 at 2:39 am

  #1632172

  You drop a linked server with sp_droplinkedserver. Obviously, if you have queries that refer to the server, these queries will stop working.

  To find instances of these servers in stored procedures, you could do:

  SELECT object_name(object_id)

  FROM sys.sql_modules

  WHERE definition LIKE '%SERVERNAME%'

  Hopefully the server names are distinct enough to make this query useful.

  Note that if it there are queries in client code, SSIS packages etc referring to these servers, the query above will not find them.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]