SQLTeam.com | Weblogs | Forums

Is there any query to find out what when was the exact time the database was deleted


Someone deleted the database.Trying to find the query when the database was deleted.


In SSMS object explorer, right-click the server name, Select Reports -> Standard Reports -> Schema Changes History.


Never tried it, but can you use fn_dblog ?


Thanks James.That works.