@@Connections

  • Thread starter Thread starter Gary Walter
  • Start date Start date
G

Gary Walter

Maybe this obvious to most of you, but....

Searching on "@@Connections" in BOL
or on Google has proven exasperating.

When I debug a Stored Proc in Query Analyzer,
what does (global) @@Connections = 117 mean?

Thank you for any help.

Gary Walter
 
Gary Walter said:
Searching on "@@Connections" in BOL
or on Google has proven exasperating.

When I debug a Stored Proc in Query Analyzer,
what does (global) @@Connections = 117 mean?
Click to expand...

Quoting BOL:
| @@CONNECTIONS
| Returns the number of connections, or attempted connections,
| since Microsoft® SQL Server was last started.

What else about @@CONNECTIONS do you want to know?

Cheers
Phil
 
Thank you Phillip.

After your post, I opened BOL directly
and there on *default Index tab* were all
the @@'s staring me in the face!

I had earlier jumped to BOL from Query
Analyzer and ran from Search tab which
basically ignored "@@'s" (as did Google).
There are a *LOT* of links to "Connection."

Every day I am humbled by what I don't know...

gary
 
Back
Top