Try this in Query Analyzer
DECLARE @LinkedServer nvarchar(30),
@IP_Id nvarchar(15),
@LoginId nvarchar(30),
@Password nvarchar(30)
SET @LinkedServer = N'SERVER'
SET @IP_Id = N'999.999.999.999'
SET @LoginId = N'UserLogin'
SET @Password = N'Password'
IF EXISTS (SELECT * FROM sysservers...