Friday, March 23, 2012

How many triggers can be added in a table

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

No comments:

Post a Comment