Trigger Related Problem....?

• SQL-290976

  SSC Enthusiast

  Points: 189

  More actions

  January 8, 2006 at 10:14 pm

  #166550

  I have a table User_Master. I implemented a After trigger For Update on this table. When i update suppose 50 records then trigger fires 50 times but my requirement is that on updation of 50 records trigger should be fire only once.

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  January 9, 2006 at 2:16 am

  #613473

  Please do not cross post.  Use this thread:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=249168

  ---

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  December 4, 2006 at 7:47 am

  #675448

  Cross-posted thread.  Best answer is on this page :

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=248311

   

  Consider this thread closed.