Quick / Built-in method for detecting table change in SQL Server?

Posted by the-locster on Stack Overflow See other posts from Stack Overflow or by the-locster
Published on 2010-03-26T11:53:24Z Indexed on 2010/03/26 12:03 UTC
Read the original article Hit count: 307

Filed under:
|

Is there a quick and easy way of telling if a table has changed in SQL Server? (I'm using SQL Server 2005). Something like an incrementing ID somewhere that updates on each INSERT, DELETE or UPDATE that I can keep track of. I noticed there is a sys.objects.modify_date column for each table, but I don't think it's quite what I want because the docs say:

Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when a clustered index on the table or view is created or altered.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2005