Session context information enables applications to set binary values of up to 128 bytes that can be referenced in multiple batches, stored procedures, triggers, or user-defined functions operating on the same session. You can set a session context value by using the SET CONTEXT_INFO statement and retrieve it later by using CONTEXT_INFO() function as in the sample code below.
SELECT CONTEXT_INFO() DECLARE @ci VARBINARY(128) SET @ci = CAST('HELLO WORLD' AS VARBINARY) SET CONTEXT_INFO @ci -- read CONTEXT_INFO() SELECT CAST(CONTEXT_INFO() AS VARCHAR(20)) -- read from DMV SELECT session_id, CAST(context_info AS VARCHAR(20)) [context_info] FROM sys.dm_exec_sessions WHERE session_id = @@SPID
More on MSDN