• Hi,thank's for your reply

    here u can find my trigger code.

    CREATE TRIGGER connection_limit_trigger

    ON ALL SERVER

    FOR LOGON

    AS

    BEGIN

    IF EXISTS(SELECT * FROM sys.server_principals AS SP WHERE [name] = SUSER_SNAME() AND type_desc IN ('Windows_Login', 'Windows_Group'))

    BEGIN

    RAISERROR('Windows LOGIN''s are NOT allowed ON this SERVER', 16, 1)

    END

    END