General discussion

Locked

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.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Networks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums