CODEWITHSUNDEEP
sql-serversql-server-2008
Developer
Developer

Reputation: 18689

Can 2 update or insert triggers be created on the same table in SQL Server 2008?

Can 2 update or insert triggers be created on the same table in SQL Server 2008?

Upvotes: 0

Views: 1575

Answers (2)

CaRDiaK
CaRDiaK

Reputation: 885

You can yes. They must have a unique name but also bear in mind subsequent triggers will have to be AFTER triggers.

Upvotes: 0

Raj More
Raj More

Reputation: 48024

Yes you can create multiple triggers on the same table.

You can also specify which is the first and the last trigger to execute. Read more here

http://technet.microsoft.com/en-us/library/ms186762.aspx

But if you have more than three triggers, you have no control over the execution order between the specified first and last triggers.

Upvotes: 3

Related Questions