Post reply

IS trigger the best option in the following senario

  • January 5, 2007 at 8:37 am

    #103295

    Hi all,

          Here is the senario, i have a large table with (say 3 million records) when ever there is a change in a particular columns data(update) , a column named "flag" in the same table has to be set to indicate a change for that particular record.

           Is trigger the best option here, i am a novice & was facing some problem to figure it out, is there any way using Referintial Integrity concept to replace triggers and improve performance.

  • January 5, 2007 at 10:07 am

    #681520

    If you do updates through stored procedures, make the change there. If you have updates through T-SQL and want to be sure they are captured, use a trigger.

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

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