How to set countext_info with linked server connection

Asked May 12 '22 at 06:40

Active May 12 '22 at 06:42

Viewed 60 times

I am connecting to a server with linked server (I call this server customerServer) , I must set context info before exec a sp in CustomerServer...but I can't set context info by linkserver....what shoud I do?

this is the Context_infi and the SP:

DECLARE @L varbinary(128) SELECT @L = CONVERT(varbinary(128), '20020154,2;@^0')
 SET CONTEXT_INFO @L 
Exec SaleCustomerDebt 
@Filter =' and Main.PlaceId in (2)',
@UserFilter = NULL,
@CustomerId = ' + @cid +',

Note: without the "Context_info", SP Result would be incomplete

edited May 12 '22 at 06:42

Dale K

25,246
15
42
71

asked May 12 '22 at 06:40

mohamad hosein bagheri

I have worked many times with linked servers and I have never used that. To me is japanese. – James May 12 '22 at 06:44
1

What exactly is it that you are trying to achieve here? – SchmitzIT May 12 '22 at 06:47
Can you not just run `EXEC LinkedServer.DB.sys.sp_executesql` with the above code (parameterized of course). – Charlieface May 12 '22 at 09:04

How to set countext_info with linked server connection

0 Answers0