How to execute sp_whoIsActive?
Create the procedure in master database.Execute the procedure from Query Analyser as below.
Code Sample :
use master go dbo.sp_WhoIsActive @get_plans=1, @get_transaction_info =1,@find_block_leaders=1,@get_locks=1
Attachment :WhoIsActive.sql