Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to track Transactions on a table

Author  Topic 

MxWebb
Starting Member

8 Posts

Posted - 2010-03-24 : 11:11:37
Here is the scoop.

I need to find away to track whats going on in table.

Something is going out and deleting or trunacating records from the table.

Look at all Jobs/SQL Agent running at 8:00 don't see anything.

Thanks
Michael Webb

Kristen
Test

22859 Posts

Posted - 2010-03-24 : 13:00:16
Audit trigger?

Save the "before" data to an Audit table, adding Time, Connected user, etc.
Go to Top of Page
   

- Advertisement -