OPC,

How could I expand on this so that if a login is not in the login table then the login is allowed. Right now if a login is not in that particular table then the login is denied.

I imagine I would need to add onto the below code

Use master

go

-- create the logon trigger

CREATE TRIGGER connection_limit_trigger ON ALL SERVER

WITH EXECUTE AS 'logon_trigger_login'

FOR LOGON

AS

BEGIN

-- the list of logins to restrict

IF (

SELECT NUM_ALLOWED

FROM GK50LIVE.dbo.LimitedLogins

WHERE LOGIN_ID = ORIGINAL_LOGIN()

) < (

SELECT COUNT(*)

FROM sys.dm_exec_sessions

WHERE is_user_process = 1

AND original_login_name = ORIGINAL_LOGIN()

)

BEGIN

ROLLBACK

END

END;

GO

something like this....

ELSE

COMMIT

END

I couldn't find any ways to allow exceptions in BOL. When I put the commit Else....Commit statement in I receive an error.

Your suggestions are welcomed. thanks.