LINKUP

-- target server name

EXECUTE
sp_addlinkedserver
@server =
N'INSTANCENAME\DEV2005',

@srvproduct =
'',

@provider =
N'SQLOLEDB',

@datasrc =
N'TARGETINSTANCE\DEV2005',

@catalog =
N''

select
*
from
sys.servers;

-- add users who want to see that

EXECUTE
sp_addlinkedsrvlogin
@rmtsrvname =
'TARGETINSTANCE\DEV2005',

@useself =
'false',

@locallogin =
'DOMAIN\hemesh.patel',

@rmtuser =
'HM_ReadONLY',

@rmtpassword =
'passwd'

EXECUTE
sp_addlinkedsrvlogin
@rmtsrvname =
'TARGETINSTANCE\UAT2008',

@useself =
'false',

@locallogin =
'DOMAIN\AsiriF',

@rmtuser =
'HM_ReadONLY',

@rmtpassword =
'passwd'

EXECUTE
sp_droplinkedsrvlogin

@rmtsrvname =
'TARGETINSTANCE\LIVE2008'
,

@locallogin =
'DOMAIN\Gihan.Desilva'