CREATE TRIGGER connection_limit_trigger
ON ALL SERVER WITH EXECUTE AS 'sa'
FOR LOGON
AS
BEGIN
DECLARE @ClientHost nvarchar(max);
SELECT @ClientHost = EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]','nvarchar(max)');
IF @ClientHost NOT IN ('<local machine>' --不要删除此条
,'192.168.2.54'
,'192.168.2.55'
,'192.168.2.56')
ROLLBACK;
END;
[sql server] 限制ip访问
最新推荐文章于 2023-02-04 15:28:15 发布