Enable SET CONTEXT_INFO
I'm using the command SET CONTEXT_INFO to pass information about current User and Application (among others) to be used with insert and updating in all the tables. In SQL Azure this command is not available because, I think, it is used to set the session GUID:
"When the client application connects to SQL Azure, CONTEXT_INFO (Transact-SQL) is set with a unique session specific GUID value automatically. Retrieve this GUID value and use it in your application to trace the connectivity problems."
We understand the scenario and are working to implement. However I don’t have a date to share right now. Please stay tuned.
Mark Hildreth commented
Nice! We are taking a similar approach and had to work around this limitation by creating a global temp table. When I googled this, there were a couple of others in the same boat. Glad to hear this is being remedied!
Venkatappa Reddy K commented
Sesha Ram prasad commented
or work around
LVPrasad Y commented
Or supply an alternative