Following are the instructions for script.
1) Execute the above SQL statement on Master Database.
2) once this stored procedure is created, execute the SP against Master DB.
Exec SP_GetBlockedInfo
To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.
Subscribing to our newsletters gets you:
Steve Jones Editor, SQLServerCentral.com