General discussion


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 104. Does anyone know what these variations mean? Even better, is there a table listing what all the bit settings refer to?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums