create trigger tr_logon_checkip on all server for logon as begin if is_srvrolemember('sysadmin') = 1 begin Declare @IPAddress NVARCHAR(15) SET @IPAddress = (SELECT EVENTDATA().value ('(/EVENT_INSTANCE/ClientHost)[1]','NVARCHAR(15)')); if not exists (select ip from test.dbo.ValiAddress where ip = @IPAddress) rollback; end; end; please help me.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)