CREATE TRIGGER connection_limit_trigger
ON ALL SERVER WITH EXECUTE AS 'sa'
FOR LOGON
AS
BEGIN
declare @IP varchar(40)
select @IP = client_net_address from sys.dm_exec_connections where session_id = @@SPID
declare @USERNAME nvarchar(128)
select @USERNAME = original_login_name from sys.dm_exec_sessions where session_id = @@SPID
if (@USERNAME) = 'BATCH_USER'
if (CONVERT(nvarchar(max),@IP) <> '<local machine>')
and
(CONVERT(nvarchar(max),@IP) <> '10.200.2.3')
begin
rollback;
return;
END
END
go