1

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, 2016 at 5:28
  • You should remove it ASAP. A person with sysadmin rights would have done it.
    – Shanky
    Jun 23, 2016 at 7:06
  • Shanky - Thanks for the advise, will remove it soon. Creating a linked server is a pro or con? Jun 23, 2016 at 7:07
  • 1
    What is Pro or Con ?
    – Shanky
    Jun 23, 2016 at 8:09
  • Is "pro or con" a shortening for "good or bad"?
    – Andriy M
    Jun 23, 2016 at 13:25

1 Answer 1

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 and acknowledge that you have read and understand our privacy policy and code of conduct.

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