How to find when a linked server was created

• Mani-584606

  SSChampion

  Points: 11788

  More actions

  July 10, 2010 at 12:29 pm

  #139773

  Hi,

  We have a Linked Server in SQL Server 2005 and I want to know who created and when it was created.

  Is there way (query) to find this information?

  Thanks

• WayneS

  SSC Guru

  Points: 95460

  More actions

  July 10, 2010 at 12:41 pm

  #1191148

  When:

  select name, modify_date from sys.servers

  Who: someone with sysadmin rights; don't know how to tell who did it.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736222

  More actions

  July 11, 2010 at 9:25 am

  #1191232

  If it was recently, the default trace should capture this.

• chandan_jha18

  SSChampion

  Points: 11330

  More actions

  April 13, 2011 at 6:45 am

  #1310980

  Steve Jones - SSC Editor (7/11/2010)

  ---

  If it was recently, the default trace should capture this.

  I am not able to find this information the default trace.Please help !