CODEWITHSUNDEEP
sql-server-2008triggers
Shiv Mohan
Shiv Mohan

Reputation: 517

How many triggers can be created on a table in SQL Server?

Is there a limit? How many triggers can be created on a single table in SQL Server?

Also is this limit changed in SQL Server 2000, 2005, 2008 and 2012.

Also there are two types of triggers INSTEAD OF triggers and For/After triggers. What is the limit on them separately?

Upvotes: 2

Views: 6425

Answers (1)

Robert Harvey
Robert Harvey

Reputation: 180858

Limited by number of total objects in database. The sum of the number of all objects in a database cannot exceed 2,147,483,647

In other words, you don't have to be concerned about this limit; you'll never hit it under ordinary circumstances.

Upvotes: 7

Related Questions