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."
47
votes
5 comments
-
Venkatappa Reddy K
commented
Yes
-
Sesha Ram prasad
commented
or work around
-
LVPrasad Y
commented
YES
-
Mark
commented
Agree
-
rop
commented
Or supply an alternative