sql server 2005 dbcc

>sqlcmd
1>

use master;
go

declare @sql VARCHAR(MAX);
set @sql=''
select @sql=@sql+'; kill ' + RTRIM(SPID)
from master..sysprocesses
where dbid=DB_ID('db_name');
exec(@sql);
go

dbcc checkdb('db_name',repair_allow_data_loss);
go

---------------------------------------------

use master;
go

declare @sql VARCHAR(MAX);
set @sql=''
select @sql=@sql+'; kill ' + RTRIM(SPID)
from master..sysprocesses
where dbid=DB_ID('db_name');
exec(@sql);
go

alter database db_name set multi_user;
go