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?
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.