Skip to navigation
Create Linked Server from a linux mssql server
22.10.26
### Create Linked Server from a linux mssql to the live ``` USE master; GO EXEC master.dbo.sp_addlinkedserver @server = N'SQL01', @srvproduct = N'', @provider = N'SQLNCLI', @datasrc = N'192.168.81.231,1433', @catalog = N'SL'; GO EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'SQL01', @useself = N'False', @locallogin = NULL, @rmtuser = N'AppsX', @rmtpassword = N'PASSWORD'; GO ``` ### Query to the linked server ``` SELECT y.[yz3_location] ,y.[yz3_karat] ,y.yz3_style ,y.[yz3_gross_wt] ,y.[yz3_qty] ,y.[yz3_fine_wt] ,isnull(yy.yz3_style,0) on_live_stock1 FROM [SL].[dbo].[yz3_stock] as y LEFT JOIN [SQL01].sl.dbo.[yz3_stock] AS yy ON y.yz3_style = yy.yz3_style AND y.yz3_karat = yy.yz3_karat AND y.yz3_location = yy.yz3_location where y.yz3_location = 1 AND yy.[yz3_style] is null order by y.yz3_style ```
Reply
Anonymous
Information Epoch 1792686575
Store numerical data in flat files.
Home
Notebook
Contact us