Triggers to track changes in indivisual columns

  • We have a case where every updation to a column (by update, i mean that tha column is changed, not that the update query is fired with no change in the column).

    Every column changed has an event id associated with it, and an row is added in another table. (This table is very crucial, since dats ia downloaded to hardware depending on the values in specific columns)

    Now I believe the Update() and the column_update() returns true even if the content has not changed.

    The only crude way of doing this seems to check the columns in the inseretd and the deleted tables. But this would mena overhead.

    And we are dealing with a very resource intense application here.

    Any suggestions??

  • check the inserted and deleted tables

    OR

    change the app to perform the logging in a transaction with the update.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

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

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