How many triggers can be added in a table?How many triggers can be added in a table?
From SQL BOL (updated version)
(topic Maximum Capacity Specifications)
Maximum triggers per table: Limited by number of objects in a database4
Note 4: 4 Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. The sum of the number of all these objects in a database cannot exceed 2,147,483,647.
Regards,
hmscott|||a better question...
are a lot of triggers on a table a good idea? probably not.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment