Database Suspect declare @veritabani as nvarchar(max); declare @sql as nvarchar(max); set @veritabani='VT'; set @sql='USE master; EXEC sp_resetstatus ''' + @veritabani + '''; USE ' + @veritabani + '; DBCC CHECKDB WITH NO_INFOMSGS; ALTER DATABASE ' + @veritabani + ' SET EMERGENCY ALTER DATABASE ' + @veritabani + ' SET SINGLE_USER DBCC CHECKDB(' + @veritabani + ', REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS; USE ' + @veritabani + '; DBCC CHECKDB WITH NO_INFOMSGS; ' exec (@sql);