Column value changed?

  • Hi guys,

    I am currently working on an application that updates a status (INT).

    I need to know when that status was last changed (DateTime) as there is no datetime stamp and this is not stored anywhere within the table.

    I have looked at the sys.traces but no luck and sys.trace_columns

    Any ideas please?

    Cheers

  • Unless you already had something set up to track changes on your tables, there is no way of doing what you require. For the future, create triggers on those tables that you need to know who changed what and when, and write this information to separate tables.

    John

  • Thanks for you reply.

    A trigger would be a more appropriate solution.

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

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