Monthly Archives: April 2016

When was the last time DBCC finished successfully


/* When was the last time DBCC finished successfully? DBCC CHECKDB checks databases for corruption. You won’t know Script is from http://sqlserverpedia.com/wiki/Last_clean_DBCC_CHECKDB_date To get sample corrupt databases – http://sqlskills.com/pastConferences.asp */ CREATE TABLE #temp ( ParentObject VARCHAR(255) , [Object] VARCHAR(255) , … Continue reading

Posted in Uncategorized | Leave a comment