Is there a place in the master db to check when inserts or updates were done for a specific table? If not, what would be the easiest way to setup logging to track when inserts and updates were done on a specific table or set of tables? Thanks in advance...
Leslie Howard (got2bfree@hotmail.com) writes: > Is there a place in the master db to check when inserts or updates were > done for a specific table? If not, what would be the easiest way to > setup logging to track when inserts and updates were done on a specific > table or set of tables? Probably to get a third-party auditing tool. Apex SQLAudit generates triggers. There are other tools that read the information from the transaction long. The other option would be to write/generate the triggers on your own. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
