I have set all Adhoc query Options
and
called the required sp in another sp
like
SELECT *
FROM OPENQUERY([Server],
'SET NOCOUNT ON; EXEC [DB].[dbo].SP ''33''')
Now I wanted to get pass the 33 which through parameter like
SELECT *
FROM OPENQUERY([Server],
'SET NOCOUNT ON; EXEC [DB].[dbo].SP '''+@Param1+'''')
but it is giving me error
Thanks All