Post reply

logging updates

  • June 28, 2004 at 7:39 pm

    #85834

    I've got a number of ASP scripts updating a particular SQL Server table.  However, this table is being updated incorrectly by one of the 10 scripts.  Is there a way to log all updates so I can troubleshoot the problem?

    Thanks.

  • June 28, 2004 at 9:34 pm

    #512330

    The easiest thing to do would be to add an update_script column to the table.  You can then just put the script that updated it in there.  Triggers won't capture this level of detail.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

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

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