April 23, 2013 at 12:33 pm
Hi SQL Guru's,
Is there any way to find out who has added any new data file or log to the database without enabling DDL triggers.
Regards
Md.S.Hassan
April 23, 2013 at 12:43 pm
Depending on volume of data and how long ago it happened, you may be able to find it in the default trace.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 23, 2013 at 12:49 pm
April 23, 2013 at 12:54 pm
Thanks Steve.. This helps:-)
April 23, 2013 at 12:55 pm
Steve Jones - SSC Editor (4/23/2013)
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/
Nice reference
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply