How to find who and when drop link server ?

Question

What is the command to find who and when drop the linked server?

I tried to find out in default trace but no evidence logged

 
select * from sys.traces
SELECT * FROM fn_trace_gettable(‘<<Path>>, default) Trace order by StartTime desc

but no luck.Please help.

Answer 1

This event is not tracked in the defalt trace nor the errorlog file, I'm afraid. So you are out of luck unless you had some other means of auditing setup.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 2

Thanks for reply TiborK.

I do not have any other auditing setup,having only default trace.It mean I never came to know who and when drop my linked server :(

Answer 3

IIRW drop linked server is done by using sp_dropserver system stored procedure which requires ALTER ANY LINKED SERVER permission on the server. Check out in your company who have such permission + sysadmin  of cause.

---

Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing