• Must be:

    CREATE TRIGGER connection_limit_trigger

    ON ALL SERVER FOR DDL_LOGIN_EVENTS

    I have gotten an error with "LOGON" clause...However msdn tell us:

    CREATE TRIGGER XYZ

    ON ALL SERVER {FOR|AFTER} LOGON ...