Home Forums SQL Server 7,2000 T-SQL extracting waitresource from a blocked process report RE: extracting waitresource from a blocked process report

  • April 9, 2013 at 11:15 pm

    #1605092

    select top 5 PATINDEX ('%waitresource=OBJECT%', TextData)

    , substring(TextData, PATINDEX ('%waitresource="OBJECT%', TextData) + LEN('waitresource="OBJECT')+1, 20)

    _____________
    Code for TallyGenerator