Export (0) Print
Expand All


SQL Server 2000

Associates up to 128 bytes of binary information with the current session or connection.


SET CONTEXT_INFO { binary | @binary_var }


binary | @binary_var

Specify a binary constant or binary or varbinary variable to associate with the current session or connection.


Session context information is stored in the context_info column in the master.dbo.sysprocesses table. This is a varbinary(128) column.

SET CONTEXT_INFO cannot be specified in a user-defined function. You cannot supply a null value to SET CONTEXT_INFO because the sysprocesses table does not allow null values.

SET CONTEXT_INFO does not accept expressions other than constants or variable names. To set the context information to the result of a function call, you must first place the function call result in a binary or varbinary variable.

When you issue SET CONTEXT_INFO in a stored procedure or trigger, unlike in other SET statements, the new value set for the context information persists after the stored procedure or trigger completes.

© 2014 Microsoft