errors when trying to run integrity check on Project Server 2002 database

[Mike Walraven]

When I try to run an integrity check on my project Server
2002 database, I get the following error:

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database
state cannot be changed while other users are using the
database 'ProjectServer'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER
DATABASE statement failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]
sp_dboption command failed.
[31] Database ProjectServer: Check Data and Index
Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair
statement not processed. Database needs to be in single
user mode.

This same error comes up if I try to manually change the
database to single user mode.

Is there any way to see which users are using the
database, close their sessions and then do the integrity
check.

This is the only database on my SQL server that I have
any issues with.

Any help would be appreciated.

Regards,
Mike Walraven

 

[Bob]

Remember that Project Server is an application accessing
the DB, so you need to ensure that all people are logged
off and all projects are checked in. Once you are sure of
this (late at night) you can re-boot the server (re-set
everything) this will be the best point to run any tests
on the database as nothing has opened any tables and the
records should be clear...