trigger order, we need a handy way to set or change trigger order
It is sometimes important to set triggers order when there are several triggers for a single table, UPDATE event, for example.
There is a command which performs this:
EXEC spsettriggerorder @triggername=N'[dbo].[tskTask_Validate]', @order=N'First', @stmttype=N'UPDATE'
But I wish I had a visualized tool for this task and more control than a simple 'First' / 'Last' option.
Thank you
1
vote
![](https://secure.gravatar.com/avatar/14c5cb16d6281ca6fa724c3c0d622b70?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)