connecting to SQL Database from asp application and setting CONTEXT_INFO

  • connecting to SQL Database from asp application and setting CONTEXT_INFO.

    <connectionStrings>

    <add name="CLHN_AppConnectionString" connectionString="Data Source=server1;Initial Catalog=CLHN_App;User ID=sa;Password=dsfsdfsfsdfs0" providerName="System.Data.SqlClient" />

    </connectionStrings>

    I would like to know if there is any way to set CONTEXT_INFO from the connection string OR there is any way to set CONTEXT_INFO every time there is a SQL connection made from asp application .

     

  • A quick google of this, it looks like CONTEXT_INFO is not a property that is available at connection time.  So you would need to SET that after connecting.  This could be done application side - when you call OPEN(), you call a stored procedure (preferred) or direct TSQL to SET the CONTEXT_INFO value.  Alternately, you could modify the stored procedures to SET the CONTEXT_INFO as the first step of the stored procedure (if this makes sense to  your process).

    Maybe not the most graceful approach, but from what I was reading, it appears to be the only approach.

    It is also being phased out in favor of SESSION_CONTEXT() from what I was reading.

    Links:

    http://www.databaseteam.org/1-ms-sql-server/617a805e0aa24198.htm <-- old link for old SQL version but they did some testing and were unable to set it with the connection string

    https://www.mssqltips.com/sqlservertip/4094/phase-out-contextinfo-in-sql-server-2016-with-sessioncontext/ <-- talks about using SESSION_CONTEXT() instead of CONTEXT_INFO() as it offers a lot of benefits in SQL Server 2016

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply