Got Corruption?

So today I’ve been dealing with one hellacious case of database corruption and thanks to the beauty of social networking I was able to get help from SQL Jedi-master Paul Randal. I’ll post my entire in an upcoming post but just wanted to share a new trick I learned. Paul posted an article tonight (thanks to my situation) about how to get back all the errors generated by your corrupted database via DBCC CHECKDB if you have more than 1,000 errors. This method involves using the osql utility. Go check out his article and stay tuned for the thrilling saga of what NOT to do with a database.