Post reply

Column value changed?

  • October 21, 2010 at 6:11 am

    #388062

    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

  • October 21, 2010 at 6:16 am

    #1240226

    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

  • October 21, 2010 at 6:27 am

    #1240232

    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