I'm using SQL Server 2000 and I'm working as a DBA in a development environment. I want to know the list of objects deleted in a database. I've setup the trace with Object:Created and Object
eleted and I capture the trace data in a SQL Server table. I've selected the data columns object id, object name, object type, host name, etc. But if a table is deleted, trace doesn't show the name of the object in the objectname column, but it shows the correct object id. Since the table is dropped, it doesn't have the entry in sysobjects. So, I'm not able to retrieve the dropped table name.
Is there any way to find it out?
Thanks in Advance,
Manohar
eleted and I capture the trace data in a SQL Server table. I've selected the data columns object id, object name, object type, host name, etc. But if a table is deleted, trace doesn't show the name of the object in the objectname column, but it shows the correct object id. Since the table is dropped, it doesn't have the entry in sysobjects. So, I'm not able to retrieve the dropped table name. Is there any way to find it out?
Thanks in Advance,
Manohar