Alternatives to CONTEXT_INFO on SQL Azure

Hi,

We use CONTEXT_INFO in an application we currently are looking to move to SQL Azure however CONTEXT_INFO is already used to troubleshooting purposes by SQL Azure. Are there any built in alternatives in SQL Azure?

Thanks,

August 29th, 2010 6:52pm

Hi,

We use it to enable security to row level data. As we use a single connection string as part of a trusted subsystem design, it stores the userId of the requestor and then data is filtered based on that.

So when a request is made to the database, CONTEXT_INFO is always set first then the request for data. Make sense?

Thanks,

Ross

 

 

  • Marked as answer by rossco_1 Saturday, September 04, 2010 12:33 PM
  • Unmarked as answer by rossco_1 Monday, September 06, 2010 8:38 AM
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2010 7:46am

Yes, CONTEXT_INFO is available for use in the latest Azure SQL Database Update (V12). So this is no longer an issue, and of course it can be used as described in the Row-Level Security post.

March 16th, 2015 4:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics