SQL SERVER How to repair corrupted database?

In this tutorial I will show you how to repair a corrupted sql server database.

Please do visit my blog.
http://codebind.blogspot.com/

—————————————————–
DBCC CHECKDB (PMS) WITH NO_INFOMSGS, ALL_ERRORMSGS
go
ALTER DATABASE PMS SET SINGLE_USER WITH ROLLBACK IMMEDIATE
go
DBCC CHECKDB ( PMS , REPAIR_ALLOW_DATA_LOSS ) WITH ALL_ERRORMSGS
go
ALTER DATABASE PMS SET MULTI_USER WITH ROLLBACK IMMEDIATE