Posted by Erland Sommarskog on 12/26/06 22:24

Marcelo (Marce.Fernandezi@gmail.com) writes:
> Hi I would like to know about connections of sa, where SQL store the
> number of connections

The number of connections of sa? I'm not sure that I understand the
question.

Current conections are, as far as I know, not stored anywhere else than
in main memory. If SQL Server dies, then the connections are broken, and
all information about them are lost.

If this was not what you were asking for, maybe you could clarify?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]