Who answers to me that how many limited users connected to MSSQL 2005 at once.
Thanks in advance.

In a query windows, exec the following:

EXEC sp_configure

In the Results pane, scroll down until you see "user connections" in the Name column. Then look to the right and you will see Minimum and Maximum values. The minimum is 0 and the Maximum (default) is 32767.


Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

To see who is running, run the following in a query Window:

EXEC sp_who

OR

EXEC sp_who2

Records with a spid over 50 is a user. This will tell you how many users are currently connected.

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

Thanks.
And what about MSSQL 2005 express?

Hmmm, good question. Honestly, I wouldn't think it limits the number of users.

I checked the following link and couldn't find anything about number of supported users.

http://www.microsoft.com/sql/prodinf...-features.mspx

However, Express wasn't meant to go running hundreds of users.

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

Thank you very much. This information is very useful for me.
Thanks again.
SLKT