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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy