Every
organization have different work environment, culture and network
infrastructure. After getting place in new organization I am learning new things and comparing all those about past windows, db , application & processes .
Today what I want to sharing is related to Link server. In previous organization we were using SQL Server login & here is windows login. So now I have to create Link server through window login. I used below query.
Today what I want to sharing is related to Link server. In previous organization we were using SQL Server login & here is windows login. So now I have to create Link server through window login. I used below query.
EXEC master.dbo.sp_addlinkedserver @server = N'WIN-DPR7D08JMDR', @srvproduct=N'SQL Server'
/* For security reasons the linked server remote logins
password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'WIN-DPR7D08JMDR',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
How to
access data using link server.
SELECT [ID] ,[location]
,[holidays] ,[date] ,[year]
FROM [WIN-DPR7D08JMDR].[ScreeningTest].[dbo].[holiday_list]