Invalid object name ‘sys.objects’.

My this blog post is about downgrading a database of SQL 2005 to SQL 2000.  This can be done by the option available in MS SQL 2005. 

1. Just right-click over the desired SQL 2005 database, select Tasks -> Generate Scripts. 
2. Select the objects needed to be scripted. But make sure you set the option of Script of SQL Version to SQL Server 2000. (see image below)
3. Run the generated Script against the SQL 2000 database.
4. Ideally this will be all you need but if it gives the error “Invalid object name ‘sys.objects’.” you will need some workaround done manually.
5. You have to replace object and column names of SQL 2005 database to downgrade the database to SQL 2000. 
6. Replace sys.objects into sysobjects and 
7. Replace object_id into id
8. Now run the script again and that should be all.  

Hope that helps.