Post reply

Two DDL database triggers

  • December 3, 2008 at 10:38 pm

    #132542

    Hi,

    We are having multiple people and multiple opinions, so the situation is that we may have two DDL database triggers logging schema changes to two different tables. Can having two such triggers possibly cause any problems?

    Thanks.

  • December 3, 2008 at 10:51 pm

    #907359

    Roust_m (12/3/2008)

    Hi,

    We are having multiple people and multiple opinions, so the situation is that we may have two DDL database triggers logging schema changes to two different tables. Can having two such triggers possibly cause any problems?

    Thanks.

    No. but their functionality should not prevent the working of each other.

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • December 4, 2008 at 1:22 am

    #907404

    If the triggers are on the same event, why not just have one trigger that does the work of both?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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