If you want to store the time a row is inserted, create a default on it with a value of getdate() e.g. create table foo ( bar datetime default getdate() ) If you want to know the time a row is updated, try using a trigger and setting the time (via getdate) in the trigger. store your internet favourites online - www.my-faves.co.uk
