Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

SQL sysobjects.status for Triggers

Locked

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?

Topic