[sql server] 限制ip訪問

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;