SQLTeam.com | Weblogs | Forums

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


#1

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


#2

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


#3

Never tried it, but can you use fn_dblog ?


#4

Thanks James.That works.