Home Forums SQL Server 2008 SQL Server 2008 - General parsing blocked processes report RE: parsing blocked processes report
chukara1
SSC Enthusiast
Points: 136
More actions
January 16, 2014 at 4:14 am
#1680581
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))',
'varbinary(max)')
etc
that would help