Identify Incoming DB Links to a SQL Server

• Cybeh

  SSC Enthusiast

  Points: 183

  More actions

  May 10, 2015 at 10:42 pm

  #318085

  Hi,

  We are doing a review of a SQL 2008 server. Though we can identify what are the linked servers to the database.

  However is there a sure shot way to identify, incoming DB links to the database server. I know the successful connections are easy to identify, but I wish to know all possible incoming DB links to server.

  Will the DB logs help in identifying all attempted and successful DB link connections.

  Thanks

• Lowell

  SSC Guru

  Points: 323527

  More actions

  May 11, 2015 at 7:26 am

  #1796954

  from the connection side, you cannot tell if an ODBC connection is a linked server on the far end, or a application or anything like that.

  If you've been smart and are using Registered Servers or Central Management Servers to administer all your servers, you should be able to simply query sys.servers on every SQL Server, and document your linked servers that way.

  something like this to get you started:

  SELECT *

  FROM sys.servers

  WHERE product = 'SQL Server'

  AND server_id > 0;

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!