SQL2005中限定IP访问SQL Server

代码如下 ：创建一个触发器

USE master
GO
ALTER TRIGGER tr_LoginCheck
ON ALL SERVER
FOR LOGON
AS
IF EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'varchar(15)') <> '133.124.42.104'
    ROLLBACK TRAN
GO

Drop TRIGGER tr_LoginCheck ON ALL SERVER