MSG 208: Invalid object name 'sysobjects'

The following error occurs when querying sysobjects:

MSG 208, level 16, state 1, line 2
Invalid object name 'sysobjects '.

 

The possible cause is that the database is case sensitive.If your database is created with a case sensitive collation then all object names will be case sensitive (msdn ).

 

-- View the collcation of the current database

Select
Convert (sysname, databasepropertyex (db_name (),
'Colation '))

Select
Collation_name from
SYS. Databases
Where name
= Db_name ()

 

My database is: chinese_prc_cs_ai (case sensitive)

 

Use lower case:

Select *
From SYS. Objects

Select
Name, schema_id, Schema_name (schema_id)
From SYS. system_objects
Where name
= 'Objects'

 

Run DBCC checkdb if it is not case sensitive.