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

SQL Server Administration
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.

1 Like
3

Never tried it, but can you use fn_dblog ?

4

Thanks James.That works.