Groups | Blog | Home
all groups > sql server clients > march 2005 >

sql server clients : @@Connection


John
3/24/2005 1:50:06 PM
When I use TSQL Debugger it will open three windows... I wanna ask about the
second windows. it gave me output like that


Name (Globals) Value (Globals) Type
(Globals)
@@connections 38
int
@@transcount 0
int


I only trying to debug on stored procedure and it's giving me @@connection =
38.. can any one explain me...

Thanks

Sue Hoegemeier
3/24/2005 7:20:24 PM
@@connections is the total number of connection attempts
since SQL Server last started. It's not the number of users
but rather the connections. You can find more information in
books online under: @@connections

-Sue

On Thu, 24 Mar 2005 13:50:06 -0500, "John"
[quoted text, click to view]
John
3/24/2005 9:31:58 PM
Thanks sue...

[quoted text, click to view]

AddThis Social Bookmark Button