why it is not possible to execute this way set context_info convert(varbinary(128), 'xyz')

Question

Viewing 4 posts - 1 through 3 (of 3 total)

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

Erland Sommarskog SSC-Insane Points: 24038 More actions · Answer 1

Because the sky is blue.

T-SQL as a programming language is fairly primitive, and far from all commands accepts variables or expression where you want them to.

If you feel that this is important, submit a suggestion on http://connect.microsoft.com/sqlserver/feedback. Don't hold your breath, though.

[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

mote.ajit2 Old Hand Points: 308 More actions · Answer 2

Thanks! 🙂

as I wanted to write that statement in single statement but I think I have to right multiple statements like

DECLARE @context varbinary(128)

SET @context = CAST('xyz' AS varbinary)

SET CONTEXT_INFO @context

Erland Sommarskog SSC-Insane Points: 24038 More actions · Answer 3

Note that it is a little tricky. See this section on my web site:

http://www.sommarskog.se/grantperm.html#context_info. Note that you only need to read down to the next header.

[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]