Post reply

invalid object name dbo.sysfiles

  • March 5, 2005 at 7:43 am

    #85556

    I have some databases ..i guess they have corrupted.when I right click on the db in EM and click properties I get a msg "invalid object name dbo.sysfiles."when I click ok button i get another msg "invalid object name dbo.sysfilesgroup" i again click ok on this msg.I get new msg "Could not get property information for database "deslldb".neither I m able to see the tables,views,sp,users when i click resp links on the treeview of db.

    When i executed sp_tables in this db..i am shocked to see that none of the system table

    have table_owner field as dbo.All these system tables and views have blank field for Table_owner colum.How to fix this problem and make the dbs healthy.

    I also querried sysusers table of this db , but shocked to see that the name feild has dbo missing.Though uid status and other fields are there.Pls help

  • March 6, 2005 at 3:33 am

    #545625

    Here's along shot. try detach and attach the DB. this way u will be able to give it a new owner.

  • March 6, 2005 at 11:23 pm

    #545654

    I did the same but still I am getting the same error.Our cleint is unable to use  the db..pl s help.this is urgent

  • March 7, 2005 at 4:27 am

    #545679

    Have you tried to run DBCC CHECKDB against your dbs? If so what were the results?

  • March 7, 2005 at 5:45 am

    #545689

    DBCC results for 'accounts'.

    DBCC results for 'sysobjects'.

    There are 153 rows in 3 pages for object 'sysobjects'.

    DBCC results for 'sysindexes'.

    There are 146 rows in 7 pages for object 'sysindexes'.

    DBCC results for 'syscolumns'.

    There are 531 rows in 11 pages for object 'syscolumns'.

    DBCC results for 'systypes'.

    There are 26 rows in 1 pages for object 'systypes'.

    DBCC results for 'syscomments'.

    There are 131 rows in 15 pages for object 'syscomments'.

    DBCC results for 'sysfiles1'.

    There are 2 rows in 1 pages for object 'sysfiles1'.

    DBCC results for 'syspermissions'.

    There are 19 rows in 1 pages for object 'syspermissions'.

    DBCC results for 'sysusers'.

    There are 13 rows in 1 pages for object 'sysusers'.

    DBCC results for 'sysproperties'.

    There are 0 rows in 0 pages for object 'sysproperties'.

    DBCC results for 'sysdepends'.

    There are 309 rows in 1 pages for object 'sysdepends'.

    DBCC results for 'sysreferences'.

    There are 33 rows in 1 pages for object 'sysreferences'.

    DBCC results for 'sysfulltextcatalogs'.

    There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.

    DBCC results for 'sysfulltextnotify'.

    There are 0 rows in 0 pages for object 'sysfulltextnotify'.

    DBCC results for 'sysfilegroups'.

    There are 1 rows in 1 pages for object 'sysfilegroups'.

    DBCC results for 'dtproperties'.

    There are 7 rows in 1 pages for object 'dtproperties'.

    DBCC results for 'afm.AnswerOptions'.

    There are 1413 rows in 6 pages for object 'afm.AnswerOptions'.

    DBCC results for 'afm.Dialog_Text_Content'.

    There are 424 rows in 7 pages for object 'afm.Dialog_Text_Content'.

    DBCC results for 'afm.Test_Content'.

    There are 191 rows in 9 pages for object 'afm.Test_Content'.

    DBCC results for 'afm.Activity_Content'.

    There are 617 rows in 20 pages for object 'afm.Activity_Content'.

    DBCC results for 'afm.Questions'.

    There are 958 rows in 5 pages for object 'afm.Questions'.

    DBCC results for 'AF_Users'.

    There are 44 rows in 1 pages for object 'AF_Users'.

    DBCC results for 'Activities'.

    There are 134 rows in 1 pages for object 'Activities'.

    DBCC results for 'activity_content_bkp'.

    There are 617 rows in 20 pages for object 'activity_content_bkp'.

    DBCC results for 'Activity_Logs'.

    There are 1802 rows in 19 pages for object 'Activity_Logs'.

    DBCC results for 'AnswerOptions_bkp'.

    There are 1413 rows in 6 pages for object 'AnswerOptions_bkp'.

    DBCC results for 'Answers_tmp'.

    There are 449 rows in 8 pages for object 'Answers_tmp'.

    DBCC results for 'Attendance'.

    There are 0 rows in 0 pages for object 'Attendance'.

    DBCC results for 'Attestation'.

    There are 1 rows in 1 pages for object 'Attestation'.

    DBCC results for 'ContactClass'.

    There are 2 rows in 1 pages for object 'ContactClass'.

    DBCC results for 'Coursefee'.

    There are 18 rows in 1 pages for object 'Coursefee'.

    DBCC results for 'Courses'.

    There are 1 rows in 1 pages for object 'Courses'.

    DBCC results for 'Dialog'.

    There are 25 rows in 1 pages for object 'Dialog'.

    DBCC results for 'Dialog_Content'.

    There are 150 rows in 1 pages for object 'Dialog_Content'.

    DBCC results for 'dialog_text_content_bkp'.

    There are 424 rows in 7 pages for object 'dialog_text_content_bkp'.

    DBCC results for 'Error_Log'.

    There are 0 rows in 0 pages for object 'Error_Log'.

    DBCC results for 'Focus'.

    There are 25 rows in 1 pages for object 'Focus'.

    DBCC results for 'Focus_tests'.

    There are 69 rows in 5 pages for object 'Focus_tests'.

    DBCC results for 'ForumTypes'.

    There are 2 rows in 1 pages for object 'ForumTypes'.

    DBCC results for 'Groups'.

    There are 9 rows in 1 pages for object 'Groups'.

    DBCC results for 'PaymentMode'.

    There are 3 rows in 1 pages for object 'PaymentMode'.

    DBCC results for 'PaymentStatus'.

    There are 3 rows in 1 pages for object 'PaymentStatus'.

    DBCC results for 'Payments'.

    There are 41 rows in 1 pages for object 'Payments'.

    DBCC results for 'Personal_Details'.

    There are 44 rows in 1 pages for object 'Personal_Details'.

    DBCC results for 'question_bkp'.

    There are 958 rows in 5 pages for object 'question_bkp'.

    DBCC results for 'RegistrationDetails'.

    There are 41 rows in 2 pages for object 'RegistrationDetails'.

    DBCC results for 'Scores'.

    There are 5 rows in 1 pages for object 'Scores'.

    DBCC results for 'Sequences'.

    There are 5 rows in 1 pages for object 'Sequences'.

    DBCC results for 'Templates'.

    There are 15 rows in 1 pages for object 'Templates'.

    DBCC results for 'test_content_bkp'.

    There are 191 rows in 9 pages for object 'test_content_bkp'.

    DBCC results for 'Test_Detail'.

    There are 46 rows in 1 pages for object 'Test_Detail'.

    DBCC results for 'Tests'.

    There are 5 rows in 1 pages for object 'Tests'.

    DBCC results for 'UserTypes'.

    There are 4 rows in 1 pages for object 'UserTypes'.

    DBCC results for 'forums'.

    There are 0 rows in 0 pages for object 'forums'.

    DBCC results for 'messages'.

    There are 0 rows in 0 pages for object 'messages'.

    CHECKDB found 0 allocation errors and 0 consistency errors in database 'accounts'.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  • March 7, 2005 at 7:24 am

    #545701

    it seems to be logical rather than physical corruption of system catalog. I'm afraid that there is no easy way out without exposing yourself to potential future problems. The safest way is in my opinion to create new database with the same structure and transfer the data using bcp, DTS or INSERT/SELECT script. Not very encouriging, though. 

  • March 7, 2005 at 7:51 am

    #545707

    Something you might want to try is add an entry for dbo in sysusers. It should have a uid of 1.You can copy the values for all the fields from another database. 

    Please note that updating system tables is not recommended and probably what martin suggested would be your best bet.

  • October 28, 2005 at 2:15 am

    #600827

    Hello,

    I have the same problem than aaronsandy, but it is impossible for me to add an entry "dbo", because I can't reach table sysuser (Invalid object name 'sysusers' or Invalid object name 'dbo.sysusers'.)

    The sp_attach_db teminated successfully, but I can't use my database anymore...

    If someone has an idea or explanation...

    BR

  • October 28, 2005 at 3:44 am

    #600837

    The posted CHECKDB output is missing some of the system tables for SQL Server 2000 including sysindexkeys, sysconstraints, sysdepends, sysprotects and sysforeignkeys.

    Check to see if these table exist within your user database. Did you post the full output of CHECKDB ?

    Some additonal activities you could perform:

    Run sp_configure and check the value for "allow updates". If this value is 1, then changes to the system tables are allowed and perhaps someone dropped some system tables.

    Check the model database to insure that all system tables exist.

    Try restoring to a different database name from different backups and try to identify when the system tables disappeared. If you have transaction log backups, try using a transaction log reader to detemine if the any of the system tables were dropped (http://www.logpi.com)

    Martin Mojzisek suggested pulling the data into a new database.

    If all else fails, contact Microsoft but they will charge you to get the data out of your database.

    SQL = Scarcely Qualifies as a Language

  • October 9, 2008 at 1:46 pm

    #883123

    I got errors 'select permission denied on sysfiles', 'select permission denied on sysfulltextcatalogs', etc depending on what task was attempted. Turns out someone had revoked select permission on system tables to the role 'public'. Granting select on systables directly to the affected user did not fix the problem; granting select on sys% tables to the role 'public' fixed the problem.

  • May 9, 2011 at 11:36 pm

    #1322087

    Hi;

    I m facing same issue.

    error 208: invalid object name 'dbo.sysusers'

    even at the time of granting permission to app user on database it is showing same message.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply