Trigger Flags in Sysobjects

• Abhijit More

  SSCertifiable

  Points: 6897

  More actions

  September 2, 2008 at 3:33 am

  #197107

  As every one knows in SQL we can create trigger for 3 operations Insert / Update / Delete

  Can anyone tell me then why Microsoft has defined this flag in sysobject

  SELECT deltrig, instrig, updtrig, seltrig, * FROM sysobjects

  Abhijit - http://abhijitmore.wordpress.com

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  September 4, 2008 at 12:23 pm

  #867347

  See http://msdn.microsoft.com/en-us/library/ms177596.aspx