HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.securitytools » Logging Inserts and Updates
Topic: Logging Inserts and Updates
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...
Replies below ↓
Replies
Re: Logging Inserts and Updates
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