How can we help you today? How can we help you today?

Invalid object name 'sysproperties' on SQL Compare v3

I removed SQL 2000 from my server and replaced it with SQL 2005.
Then I created 2 empty databases, didn't add any tables, stored procedures etc, then tried to compare them with SQL Compare (version 3.1.7.218 :oops: )
The following error appears:
Invalid object name 'sysproperties'

(The reason why I did this was I have an application that uses SQL Toolkit to compare 2 dbs, one of the dbs was accessing sysproperties in a stored proc - I removed the proc but am still getting the error. So I tried it using SQL Compare. Same error. So I created the 2 empty databases.. same error.)

Is it a SQL Compare v3 / SQL 2005 compatibility issue? Do I need to upgrade?
derryharrow
0

Comments

1 comment

Sort by
  • Tom Harris
    Hi there,

    SQL Compare 3 predates SQL Server 2005 by some time ;-) You'll want to upgrade to the latest version of SQL Compare. You can quickly download a trial that should keep you going for 14 days. Good luck,

    Tom
    Tom Harris
    0

Add comment

Please sign in to leave a comment.