Category Archives: Linked Server

Linked Server


exec sp_dropserver @server = ‘WMSREPLICADB’ ,@droplogins = ‘droplogins’

go

 

EXEC sp_addlinkedserver

@server = ‘WMSREPLICADB’ ,

@srvproduct = ”,

@provider= ‘SQLOLEDB’,

@datasrc=  ‘100.64.0.152’  

GO

 

sp_addlinkedsrvlogin

@rmtsrvname = ‘WMSREPLICADB’  

 ,@useself = ‘FALSE’    

 ,@locallogin = ‘SQLDBA’     

,@rmtuser  = ‘portaluser’     

,@rmtpassword =  ‘portaluser’

GO

 

select top 1 * from [WMSREPLICADB].[geo].[geo1].[sku]

GO

 

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N’WMSREPLICADB’, @locallogin = NULL , @useself = N’False’, @rmtuser = N’portaluser’, @rmtpassword = N’portaluser’

%d bloggers like this: