How can we improve Azure SQL Database?

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."

72 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Juan Pablo PérezJuan Pablo Pérez shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for your feedback. We now have the next generation of Azure SQL DB in public preview in the US and GA in Europe.
    Specifically it supports SET CONTEXT_INFO
    Details here http://azure.microsoft.com/blog/2014/12/11/preview-available-for-next-generation-of-azure-sql-database/ and https://msdn.microsoft.com/library/azure/ee336281.aspx#UpgradeSterling

    9 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base