Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Logging Inserts and Updates
0 views
Skip to first unread message
Leslie Howard
May 29, 2008, 3:18:01 PM5/29/08
to
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?
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...
Erland Sommarskog
May 29, 2008, 5:38:21 PM5/29/08
to
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, esq...@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
0 new messages