0

I came across a linked server that is pointing to production from test environment with full access. Is there a way to find out who and when this linked server was created? Based on last modified date, I came to know this was created long back so but with least hope I took a look into default trace - as expected there is no luck.

My test server version is 2008R2.

6
  • It is difficult to trace unless there is some kind of audit is configured. – SQLPRODDBA Jun 23 '16 at 5:28
  • You should remove it ASAP. A person with sysadmin rights would have done it. – Shanky Jun 23 '16 at 7:06
  • Shanky - Thanks for the advise, will remove it soon. Creating a linked server is a pro or con? – Sunil Kumar Jun 23 '16 at 7:07
  • 1
    What is Pro or Con ? – Shanky Jun 23 '16 at 8:09
  • Is "pro or con" a shortening for "good or bad"? – Andriy M Jun 23 '16 at 13:25
4

The sys.servers data dictionary view will give you the date that the Linked Server entry was modified/created (modify_date column), but not who created it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.