• The executed code are:

    CREATE TRIGGER connection_limit_trigger

    ON ALL SERVER WITH EXECUTE AS 'navi'

    FOR LOGON

    AS

    BEGIN

    IF ORIGINAL_LOGIN()= 'navi' AND

    (SELECT COUNT(*) FROM sys.dm_exec_sessions

    WHERE is_user_process = 1 AND

    original_login_name = 'navi') > 3

    ROLLBACK;

    END;

    The user navi is sysadmin.

    /René