Ars Technica

Any alternative to recursive sql stored procedure?

I'm having an issue with an ASP page occasionally timing out. The specific error is the following:<BR><BR>"*.DBCommand.Execute(): Microsoft OLE DB Provider for SQL ...
Visual Studio Magazine

Identify Blocked SQL Processes Quickly: Figure 3 Run the dba_BlockTracer Stored Procedure.

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 ...