Home Forums SQL Server 2008 SQL Server Newbies Deleting logon trigger. RE: Deleting logon trigger.

  • December 5, 2011 at 9:50 am

    #1416814

    zorge (12/5/2011)

    Yet, for some reason the LOGON trigger on ALL SERVER is not listed in sys.triggers.

    No mysterious reason. Sys.triggers is for database-scoped triggers. You'll find server-scoped triggers in sys.server_triggers

    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