Viewing 2 posts - 1 through 3 (of 3 total)
i dont care what you're doing now. i've just provided you with the exact answer to you question. Read it carefully
January 16, 2014 at 10:30 am
#1680762
try this
CAST(textdata AS XML).value('xs:hexBinary(substring((/blocked-process-report[1]/blocked-process[1]/process[1]/executionStack[1]/frame[1]/@sqlhandle)[1],3))',
...
January 16, 2014 at 4:14 am
#1680581