Hi, how can I pass a parameter for the LinkedServer to an openquery? I am receiving the following error:
Incorrect syntax near '+@LinkedServer+'.
declare @LinkedServer char(50)
set @LinkedServer = 'Server1';
select * from
openquery
(
'+@LinkedServer+',
'SELECT * from table1'
)
thank you in advance for your help,