ALTER DATABASE [DBName] SET EMERGENCY;
GO
ALTER DATABASE [DBName] set single_user
GO
ALTER DATABASE [DBName] set single_user
GO
DBCC CheckDB (‘[DBName]’) WITH ALL_ERRORMSGS
GO
ALTER DATABASE [DBName] SET OFFLINE
GO
ALTER DATABASE [DBName] SET ONLINE
GO
ALTER DATABASE [DBName] SET MULTI_USER
GO