Sql server 2000, I think SQL 7 as well

To set a database to single user mode so you can run DBCC,
from query window:

ALTER DATABASE MyDatabase SET SINGLE_USER

When you are done:

ALTER DATABASE MyDatabase SET MULTI_USER