New User ? Sign Up  |  Sign In  |  Help
ask
answer
discover
     
Search for questions :
My Profile
Categories

princy

Open Question Bookmark and Share

Problem in accessing SQL server 2005 database tables?

I am not able to access one of the SQL server database table, I ran DBCC CHECKCATALOG but it gives error, it comes up as Msg 3853 level 16 state 1, line 1
Attribute (referenced_object_id=729769657, referenced_column_id=1) of row (constraint_object_id=873770170, constraint_column_ id=1) in
sys.foreign_key_columns does not have a matching row… and a long error log report was there, completely out of my understandability. Followed by –DBCC execution completed. If DBCC printed error messages contact your system administrator.

On using EXEC sp_resetstatus ‘EPP’, and other alter and DBCC command- it says suspect flag is already reset, possible schema corruption run DBCC CECKCATALOG which again gives error message as severe error occurred. Does anyone know how this issue can be fixed?

622 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

sania77
Database table schema is corrupted which makes its accessibility impossible and in such cases even dropping the corrupted table is not helpful despite of loss of significant data. so you should better create a database(new) having schema & empty tables same as the previous one has. The data can now be copied from original database, after which new database will be replace the first one.

Still, if problem continues you should try repairing database with third party my sql repair tool. As database is exhaustively scanned to fix errors and data restored to new database.


Posted 622 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0