Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Connection limit on database level

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-20 : 09:13:36
Ludo writes "Can someone help me with the following problem:
I'm a SQL server DBA and we sell intern SQL-Server resources to the application teams based on needed storage and number of users.
I have several servers shared by different application teams.

Now I'm looking for a method to limit the number of users working together on a specified Database. Because when a project manager wants resources for 100 users I want to be sure that only 100 users can connect to that particular database at the same time.

I know I can limit the number of connections on server level but I need this on Db level too.

Can you please help me?

I want to implement this on SQL 7.0 sp3 and SQL 2000 sp1"
   

- Advertisement -