Is there a way to find out who dropped a database in SQL Server 2005 and the time / date that it was dropped?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Mar 1 '12 at 8:07
This question came from our site for professional and enthusiast programmers.
If it was recent enough, it may still be in the default trace. The basic assumption will be that the DROP event will be the last event recorded for this database. So if someone dropped the database 'splunge' you should be able to catch it this way (again depending on how long ago it happened):