From: "Chip Smith " <mssqldba-ezmlmshield-x86105647.[Email Address Removed] Subject: RE: DBCC CHECKDB Errors Date: Thu, 31 Mar 2005 10:29:51 -0700
ALTER DATABASE 'database_name' SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CHECKDB ( 'database_name' ,REPAIR_ALLOW_DATA_LOSS ) ALTER DATABASE 'database_name' SET MULTI_USER