Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RickyS2011
Starting Member
2 Posts |
 Posted - 2011-10-06 : 12:59:49
|
| I need to know who created a linked server on our of our production machine. I've tried all three of these, but nothing tells me who did it.select * from sys.serversselect * from sys.remote_loginsselect * from sys.linked_loginsIs there a way, or is this not captured?Thanks! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-10-06 : 14:25:28
|
| You'd have to write a DDL trigger on the server to capture linked server events, listed here: http://msdn.microsoft.com/en-us/library/bb522542.aspx |
 |
|
|
RickyS2011
Starting Member
2 Posts |
Posted - 2011-10-06 : 14:29:05
|
| Great thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
srinivasarao.gandi53
Starting Member
2 Posts |
Posted - 2011-10-07 : 05:07:12
|
| how can i create linked serverg.srinivasarao |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Linked Server - URGENT