Record Inserted/Updated Timestamp

  • Hello

    I'm new to SQL Server.

    For a given table, can we identify when was a particular record Inserted/Updated, by using system tables?

    Can some one help me please..!

    Cheers,

    Kanthi

  • you can not determine when a record was inserted or updated unless you have either a trigger setup to record a timestamp or some form of record auditing is active. by default however there are no system veiws or tables that would give you that information.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply