sp_who3 has been updated in the FAQs 2

[mrdenny]

For everyone who uses sp_who3 from my FAQ faq962-6561 I've updated the SQL 2005 version of sp_who3 so that it now correctly displays the full text of the batch when run against a single spid.

Hopefully you all find this update usefull.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[onpnt]

Thanks Denny

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[mrdenny]

I've made another update to this procedure which you may find useful. When running it for a single spid in addition to giving you the full command or procedure code which is being run it will also give you the current command within the proceudre which is currently running.

I hope that you find this feature useful.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com