CREATE TRIGGER [tr_connection_limit]
ON ALL SERVER WITH EXECUTE AS '管理员'
FOR LOGON
AS
BEGIN
--限制test这个帐号的连接
IF ORIGINAL_LOGIN()= '受限账号'
--允许test在本机和下面的IP登录
AND
(SELECT EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'NVARCHAR(15)'))
NOT IN('<local machine>','其他允许IP')
ROLLBACK;
END;