20151029 [FIND DELETED OBJECT THROUGH TRNSACTION LOG]
Thursday, October 29, 2015 (PST)
The following query will return user name and transaction id, and detail transaction info.
You will not be able to find the deleted object name.
[Transaction Name] = 'DROPOBJ'
To find out deleted object name. You need to use the following query to find it from the backup database with the transaction id.
TOP (1) [Lock Information]
fn_dblog (NULL, NULL)
[Transaction Id] = '0000:006d8c63'
AND [Lock Information] LIKE '%SCH_M OBJECT%'