Monday, June 22, 2009

Set User Context in DB

CREATE PROCEDURE [COMMON].[usp_tax_set_context_user](
@p_USERNAME varchar(50)
)
AS

DECLARE
@v_CONTEXT_INFO VARBINARY(128)
BEGIN
SET @v_CONTEXT_INFO = CONVERT(VARBINARY(128), @p_USERNAME)
SET CONTEXT_INFO @v_CONTEXT_INFO
END

0 Comments:

Post a Comment

<< Home