Maximum Users

[itsmarkdavies]

Can anyone tell me the maximum number of (if there is a maximum) for the following :-

1. SQL Server Users per Database
2. Roles per Database
3. Connections per Server
4. Logins per Server

Thanks.

 

[Cagliostro]

Is also the maximum number of licences in SQL7 John Fill

ivfmd@mail.md

 

[tlbroadbent]

[ol][li]SQL Server Users per Database - no limit
[li]Roles per Database - no limit
[li]Connections per Server - depends on version and licensing.
[li]Logins per Server - no limit[/ol]Check out licensing on the SQL Server web site.

http://www.microsoft.com/SQL/howtobuy/pricing/default.asp

http://www.microsoft.com/SQL/howtobuy/pricing/70/pricing.asp

Terry
------------------------------------
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker