IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'game','false',null,'server name','server Password';
END
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='game', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='game', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc out', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB')
BEGIN
EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'server name','server Password';
END
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_DEFINEDB', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_DEFINEDB', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc out', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH')
BEGIN
EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'server name','server Password';
END
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_NCASH', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_NCASH', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc out', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB')
BEGIN
EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'server name','server Password';
END
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_USERDB', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_USERDB', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc out', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01')
BEGIN
EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'server name','server Password';
END
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_GAMEDB01', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_GAMEDB01', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc out', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01')
BEGIN
EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'server name','server Password';
END
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_USERDB01', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc', @
[Only registered and activated users can see links. Click Here To Register...]value='true';
exec sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]='PS_USERDB01', @
[Only registered and activated users can see links. Click Here To Register...]name='rpc out', @
[Only registered and activated users can see links. Click Here To Register...]value='true';