SQL Server timestamp

[miceisland]

Hi Guys and Gals, Your help is needed, is there any way to see when (date/time) is the specific record inserted or updated in sql server? Many Thanks. Stephen --------------------- www.islasolutions.net

[sathish s]

No. To acheive this, You need to include modifieddate, createddate columns manually in all your tables and update them.

[miceisland]

how about the transaction log, is sql server store info in this log? --------------------- www.islasolutions.net

[sathish s]

Not sure of that. Let's see, if some one could answer this..

[Felipe Dalorzo]

How about using a trigger? of course you will need to have a column to store the value but I bet that's easiest/simplest way.. Greetings, :->

[miceisland]

Thanks, actually planning to implement this in future, but for now i just want to check, if possible to can see the date of my previous records when it was inserted or updated, :sigh: think theres no other way then. many thanks to all the response :). Regards, Stephen --------------------- www.islasolutions.net