April 10, 2014 at 1:49 pm
Is there any way to create a trace, that will only trap the creation/edit of Linked Servers?
April 10, 2014 at 2:47 pm
If you are just looking to get notified when one changes or is added, you could setup a job to run this and look at the modify_date and send an email with the details of any records that have changed since the job was run last. This would only cover added and modified linked servers, NOT deleted linked servers.
select * from sys.servers where is_linked = 1
April 11, 2014 at 10:20 am
Deleting is not a problem we have... but I would like to know who is creating server links between servers that should not get created. I am currently unable to restrict access, and there are a few dozen that are likely doing it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply