Step 3:I am trynig to run a basic query from table on Server2
set ansi_nulls on
set ANSI_WARNINGS on
select A.Col1 from [Server2].[database2].dbo.[table] A
when i try the above query , i am ggeting the following error meassge:
"Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query."
Can anyone please guide if the steps i performed to setup a linked server is fine. ?? WHatelse is wrong on the queries?