> In our application, we want to store the data a record was modified.
Unfortunately timestamp data type in SQL Server has nothing to do with actal
data and time, the name is misleading.
Create your own datetime column and add a update trigger to the table -
modify the datetime column from the trigger.
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org