General discussion

  • Creator
  • #2131801

    SQL sysobjects.status for Triggers


    by timboid ·

    Is there a definitive list of what the ‘status’ number represents in the ‘sysobjects’ table for SQL triggers? I know that 256 is a DELETE trigger, 512 is an UPDATE trigger and 1024 is an INSERT trigger. These are clearly binary bit settings, but I have seen triggers with variations of these numbers (e.g. 280, 536 and 1048). Does anyone know what these variations mean? Even better, is there a table listing what all the bit settings refer to?

All Comments