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

  • December 5, 2011 at 9:52 am

    #1416819

    GilaMonster (12/5/2011)

    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

    Please note, amost 1 YO thread 😉

    Yes, I know, good point to post!