execute sys.sp_addlinkedserver @server=‘bb’,
@srvproduct=’’,
@provider=‘SQLOLEDB’,
@datasrc=‘192.168.68.98,1433\WIN-4SP9630EEIU’ ;
execute sys.sp_addlinkedsrvlogin @rmtsrvname=‘bb’,
@useself=‘false’,
@locallogin=null,
@rmtuser=‘sa’,
@rmtpassword=‘ixxx8@’ ;
execute sys.sp_addlinkedserver @server=‘zn’,
@srvproduct=’’,
@provider=‘SQLOLEDB’,
@datasrc=‘192.168.68.138,1433\SW-SERVER-138\SQL2008’ ;
execute sys.sp_addlinkedsrvlogin @rmtsrvname=‘zn’,
@useself=‘false’,
@locallogin=null,
@rmtuser=‘sa’,
@rmtpassword=‘ixx18@’ ;
go
select
- from bb.parking.dbo.xxx