Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

This SQL code runs the dba_BlockTracer stored procedure. The output shows two grids; the first shows that the root-blocking spid is 86, and the second shows two blocked spids, 122 and 104. Both spid ...

As a bonus, the following tools aren't limited to stored procedures -- they'll work with any SQL Select statement. Assuming that your stored procedure is just returning an integer result (for example, ...