Red Gate forums :: View topic - Couldn't locate object with name 'sysclsobjs' in schema ID4
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Couldn't locate object with name 'sysclsobjs' in schema ID4

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
studentstf



Joined: 18 May 2012
Posts: 1

PostPosted: Fri May 18, 2012 8:35 am    Post subject: Couldn't locate object with name 'sysclsobjs' in schema ID4 Reply with quote

I'm testing SQL Compare 10.1. I have two backups of a database about 17 GB each other, one was made on sql server 2005 before migration to sql server 2008 r2, and another after. When I try to compare these backups, Sql Compare 10.1 trial version stop working with error "Couldn't locate object with name 'sysclsobjs' in schema '' (ID 4)".
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Mon May 21, 2012 4:32 pm    Post subject: Reply with quote

I can understand why you would get this error, since sysclsobjs is a system object and therefore should be in the "SYS" schema. I don't know how the database got into this state, though. It looks as if possibly someone made manual changes to the system catalog, but SQL Server is designed to prevent you from doing that.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Mon May 21, 2012 4:39 pm    Post subject: Reply with quote

Ah, scratch that - it looks like an error in creating a view in the temporary database created to hold information about objects in the backup. SQL Compare's backup reader creates a temporary table on the hard disk and uses that to store a mock-up of the sys schema.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Tue May 22, 2012 9:55 am    Post subject: Reply with quote

Hello,

Is this situation still occurring, or was it a one-off?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Thu May 24, 2012 2:29 pm    Post subject: Reply with quote

I suppose you could delete all temoirary files (using the Windows Disk Cleanup Utility) and try again... if that doesn't work, try restoring the backup file to SQL Server... it may be corrupt.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group