Exclusive Mode

[Christine]

Hi,

When I open an application, it prompts me for a message that SQL is locked in exclusive mode by other application.

How to solve this?

thanks in advance

christine

[Claire]

In SQL Server 2000 ,the following alternative options are available by using the ALTER DATABASE command:

ALTER DATABASE database SET SINGLE_USER.
This command restricts access to the database to only one user at a time.

ALTER DATABASE database SET RESTRICTED_USER.
This command restricts access to the database to only members of the db_owner, dbcreator, or sysadmin roles.

ALTER DATABASE database SET MULTI_USER.
This command returns access to the database to its normal operating state

--From BOL

[rmiao]

Should check what does the other app do. Why have different apps access same db?

[Christine]

thankx for the help