Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Johan Bijnens Scope: The drastic caveat with Logon Triggers. RE: Scope: The drastic caveat with Logon Triggers.

  • December 19, 2008 at 6:35 am

    #915196

    ALZDBA (12/19/2008)

    Scenarion 1 : add begin tran ... commit tran

    Just encapsulating the trigger with its own Begin tran ... commit tran, off course didn't do the trick.

    Because: that tran is just an augmentation of the @@trancount which - because of the "set implicit transactions on" >0 at that time.

    When I added a while loop :crazy:

    while @@trancount > 0

    begin

    commit tran

    end

    resulted in a failure of the biztalk apps.

    Try it like this:

    Commit Tran

    IF @@trancount = 1

    Begin

    Commit Tran

    Begin Tran

    End

    [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]