hey nice script bro....

it gives trn count, lock count and start time as extra information..

but i have doubt it shows u all the sleeping procedures and commands in it..

is...

hi Ritesh,

Thanks for the query... its very useful for DBA..

i have one doubt..

how to send the output of query as an attachment.

i use

exec msdb.dbo.sp_send_dbmail

@profile_name...