Is there a way to find out who dropped a database in SQL Server 2005 and the time / date that it was dropped?
migrated from stackoverflow.com Mar 1 '12 at 8:07
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):