Post reply

How to Set the execution order of DDL Triggers

  • April 4, 2012 at 5:15 am

    #391942

    Hi ...

    Any one help to me ,

    How to Set the execution order of DDL Triggers ,

    I hvae 4 DDL triggers ,

    I have to set order of execution , because it have dependence of other DDL triggers.

    I have used this sp "sp_settriggerorder ",But How to set order for 2nd, 3rd trigger.

    Thanks

    Ramana P

  • April 4, 2012 at 5:39 am

    #1468760

    well, as you probably read over at books online about sp_settriggerorder (Transact-SQL), you can set the first trigger, and the last trigger.

    there is no way, with four triggers, to know which will fire second or third.

    you could consider combining two or more triggers into a single trigger; then you could be assured the code executes in the order the code exists inside the trigger.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

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