'How to set countext_info with linked server connection

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

sqlsql-servercontext-infoset-context-info


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions