<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
sp_who2
Items 1 to 9 of 9
usp_who5
Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.
Read more...
By
Sean Smith
2011/08/25
|
Source:
SQLServerCentral.com
|
Category:
sp_who
Rating:
|
Discuss
|
Briefcase
|
5,929 reads
Capture and Alert for Blocked SPIDS with SP_WHO2
This will capture locked/blocked spids and alert with the inputbuffer info as well as the login info. Then email it and record the history of the blocks.
Read more...
By
Joshua A. Walker
2011/04/06
|
Source:
SQLServerCentral.com
|
Category:
sp_who2
Rating:
|
Discuss
|
Briefcase
|
2,272 reads
usp_who5
Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.
Read more...
By
Sean Smith
2011/08/25
|
Source:
SQLServerCentral.com
|
Category:
sp_who
Rating:
|
Discuss
|
Briefcase
|
5,929 reads
What, When, Where, How, Who2
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
Read more...
By
Jason Brimhall
2010/06/14
|
Source:
SQLServerCentral.com
|
Category:
sp_who2
Rating:
|
Discuss
|
Briefcase
|
10,590 reads
View connection and Locking Information
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
Read more...
By
sql frenzy
2010/05/17
|
Source:
SQLServerCentral.com
|
Category:
sp_who2
Rating:
|
Discuss
|
Briefcase
|
2,208 reads
usp_who5
Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.
Read more...
By
Sean Smith
2011/08/25
|
Source:
SQLServerCentral.com
|
Category:
sp_who
Rating:
|
Discuss
|
Briefcase
|
5,929 reads
View connection and Locking Information
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
Read more...
By
sql frenzy
2010/05/17
|
Source:
SQLServerCentral.com
|
Category:
sp_who2
Rating:
|
Discuss
|
Briefcase
|
2,208 reads
usp_SQL_In_sp_who2
Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID
Read more...
By
Banyardi Schmardi
2009/04/24
|
Source:
SQLServerCentral.com
|
Category:
sp_who2
Rating:
|
Discuss
|
Briefcase
|
1,121 reads
Indepth SPID information
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
Read more...
By
Amar P
2009/01/09
|
Source:
SQLServerCentral.com
|
Category:
sp_who2
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,821 reads
Items 1 to 9 of 9
Tags
locking
(2)
sp_who
(2)
spid
(2)
activity
(1)
alerts
(1)
blocking
(1)
current activity
(1)
dbcc inputbuffer
(1)
enhancement
(1)
host ip address
(1)
input buffer
(1)
processes
(1)
sp_lock
(1)
sys.dm_exec_query_plan
(1)
sys.dm_exec_requests
(1)
sys.sysprocesses
(1)
t-sql
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
