• I'm monitoring the whole SQL Server environment with the blocked process report.

    I'm running this process in background as a job to get the informations.

    The problem is that it generated a lot of lines of blocked informations and I'm having issues to parse the information.

    Is there any script that I could get only the sqlhandle and the line of the object of the blocked and blocking process? That's all I need.

    Anyone can help me?

    Thanks