concurrent users connection - SQL Server Forums

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 Development (2000)

concurrent users connection

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-13 : 01:49:07

yossi writes "I have 2 users with public permissions in a given database
How can I configure the database to grant access only to one of them at a given time?
e.g.
If one of the users is connected, db will deny connection from the other if he tries to connect.

(but number connections of the same user will be unlimited -with the same user it will be possible to make more then one connection)

Thanks."

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2002-05-13 : 05:27:33

USE master
EXEC sp_dboption 'mydatabase', single user', 'TRUE'

When true, only one user at a time can access the database.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources