DECLARE @db nvarchar(50) set @db='' --close all connections DECLARE @SPId int DECLARE @CMD varchar(100) DECLARE my_cursor CURSOR FAST_FORWARD FOR SELECT SPId FROM MASTER..SysProcesses WHERE DBId = DB_ID(@db) AND SPId <> @@SPId OPEN my_cursor FETCH NEXT FROM my_cursor INTO @SPId WHILE @@FETCH_STATUS = 0 BEGIN SELECT @CMD = 'KILL ' + CAST(@SPId AS varchar(10)) EXEC (@CMD) FETCH NEXT FROM my_cursor INTO @SPId END CLOSE my_cursor DEALLOCATE my_cursor exec('ALTER DATABASE ['+ @db +'] SET SINGLE_USER WITH NO_WAIT') dbcc checkdb(@db, REPAIR_ALLOW_DATA_LOSS) exec('ALTER DATABASE ['+ @db +'] SET MULTI_USER WITH NO_WAIT')
try another dbcc checkdb afterwards to be sure it’s fixed