Click here to Skip to main content
14,297,572 members
Rate this:
Please Sign up or sign in to vote.
Good Evening to all.

I was working with sql server 2008.

Thing i did:

Actually i was noticed that the free space available in C drive reaches below 1 GB .So i thought to Club the D drive with C drive.I had extended the C drive to 18 GB.

Error that Occurs:

Once i finish Extending the drive size i restarted my system.After logon i opened the Microsoft Sql server Management Studio which has multiple database.Every thing works fine except the Database which i have worked recently.When try to expand the table it shows the error as

Quote:
Possible schema corruption. Run DBCC CHECKCATALOG. A severe error occurred on the current command. The results, if any, should be discarded. (.Net SqlClient Data Provider)


This is how i runned the DBCC runcheck catalog:

Quote:
DBCC CHECKDB (Demo) WITH NO_INFOMSGS, ALL_ERRORMSGS


and this is the error which i get while running the above:

Quote:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.


Can any one please help me tocome out of this rid.

Thanks in advance
Posted
Updated 26-May-14 3:13am
v2
Comments
Wes Aday 26-May-14 9:08am
   
"Run DBCC CHECKCATALOG" seems pretty self explanatory to me. What part is unclear to you?
Appdev(Icode) 26-May-14 9:10am
   
Sorry for this silly question.
I'm not aware about Run DBCC Checkcatalog.Where it exist and how to run it.
Appdev(Icode) 26-May-14 9:11am
   
DBCC CHECKDB (Demo) WITH NO_INFOMSGS, ALL_ERRORMSGS
this was the thing i used but tgis also shows error
Appdev(Icode) 26-May-14 9:11am
   
And the below is the error of that run DBCC checkcatalog.

A severe error occurred on the current command. The results, if any, should be discarded.
Andrius Leonavicius 28-May-14 15:32pm
   
Hi,

Your database seems to be corrupted. Do you have a backup?

This might be useful:
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100