sequence of Triggers

Question

Post reply

sequence of Triggers

adish

SSChasing Mays

Points: 634
More actions
December 13, 2008 at 1:36 am

#197385

Hi
Can anybody tell me how to fix a sequence for two or more triggers for the same event?
Thanks
Adish

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

As long as it is NOT more than 3 triggers you can. These 2 links will help you do that

[urlhttp://www.sqlservercentral.com/articles/SQL+Puzzles/triggerstoexecuteinpredefinedorder/2337/][/url]

also:

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

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

You can define the First trigger and the Last trigger, everything else is just in-between them, as per bitbucket's links.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

adish SSChasing Mays Points: 634 More actions · Answer 3

Thanks bitbucket and RBarryYoung, both the links were helpful.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 4

Glad we could help.

Just out of intrest: what use would you have for being able to set the order of 4 or more triggers?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

adish SSChasing Mays Points: 634 More actions · Answer 5

It was only important to set one trigger as 'Last'. The order of others was immaterial. When I said 'a sequence', it seems I did not use the appropriate word or maybe curiosity was weighing on my mind.

Thanks

Adish

RBarryYoung SSC Guru Points: 143329 More actions · Answer 6

OK, thanks.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]