<div>
Please also read <a href="http://msdn.microsoft.com/en-us/library/bb839514.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/bb839514.aspx</a>&nbsp;regarding MIN_ACTIVE_ROWVERSION, which explains the issues with using rowversion data in transactions and blocks of changes.
</div>


Please also read http://msdn.microsoft.com/en-us/library/bb839514.aspx [http://msdn.microsoft.com/en-us/library/bb839514.aspx] regarding MIN_ACTIVE_ROWVERSION, which explains the issues with using rowversion data in transactions and blocks of changes.

<div>
<div class="content wysiwyg-content">
I am using SQL Server Express 2008 and have a table where I want to know the date/time when the rows in the table are modified/added. &nbsp;Do I need to use a datetime field with a trigger to do this or is there a better way? &nbsp;Either way I would like an example to follow.
</div>
</div>


I am using SQL Server Express 2008 and have a table where I want to know the date/time when the rows in the table are modified/added.  Do I need to use a datetime field with a trigger to do this or is there a better way?  Either way I would like an example to follow.

Want date/time of every change to row in SQL Server table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.