@@Connections

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
 
P

Philipp Stiefel

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
 
G

Gary Walter

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Word 2007 files taking too long to open after new internet connection 5
EXEC sp w/ BULK INSERT - problem w/ security 2
Refresh A Table or Stored Procedure in Access ADP 1
Synchronization problems while moving folders to new email 1
getting return value from stored proc 4
CREATE PROC SYNTAX 0
Read Variant from Forms 0
"too few parameters expected" when filtering OpenRecordset 2

Top