Welcome to Aussie SQL Server Bloggers
Sign in
|
Join
|
Help
Transaction blog
This Blog
Email
Calendar
Sep
October 2005
Nov
M
T
W
T
F
S
S
26
27
28
29
30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
Search
Go
Syndication
RSS 2.0
Atom 1.0
Archives
April 2008 (4)
February 2008 (2)
January 2008 (1)
June 2007 (2)
April 2007 (4)
March 2007 (1)
December 2006 (6)
November 2006 (2)
October 2006 (1)
September 2006 (13)
August 2006 (2)
July 2006 (1)
June 2006 (2)
May 2006 (1)
April 2006 (3)
March 2006 (11)
February 2006 (3)
January 2006 (2)
November 2005 (1)
October 2005 (1)
September 2005 (1)
April 2005 (1)
March 2005 (2)
February 2005 (3)
December 2004 (5)
November 2004 (3)
October 2004 (1)
September 2004 (2)
Navigation
Home
Blogs
Photos
Post Categories
Australian SQL Server User Group (4)
Personal stuff (6)
SQL Server - other (6)
SQL Server - Scripts (9)
SQL Server - Technical (19)
October 2005 - Posts
Sunday, 2 October 2005 4:28 PM
Handy little sp_who2 script
I'm always hunting around for one of these scripts, so I'm sticking it here for ease of reference & in case its useful to anyone else.. select getdate()goif OBJECT_ID('tempdb..#spwho') > 0 drop table #spwhogocreate table #spwho ( SPID
posted by
Greg_Linwood
|
0 Comments
Filed Under:
SQL Server - Scripts