CREATE TRIGGER [tr_LoginCheck]
ON ALL SERVER
FOR LOGON
AS
IF
EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'varchar(15)') = '172.16.0.72'
ROLLBACK TRAN
GO
SET ANSI_NULLS OFF
...全文
24328打赏收藏
十万火急,请高手帮忙!!!!!!!!!!!!!!!!!!!!!!
我写了个触发器,想限制IP登录,结果所有用户所有机器都不能登录服务器了 请高手帮忙,十万火急 CREATE TRIGGER [tr_LoginCheck] ON ALL SERVER FOR LOGON AS IF EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'varchar(15)') = '172.16.0.72' ROLLBACK TRAN GO SET ANSI_NULLS OFF