We are getting following error when we are running SQL Compare 8 against two Databases in SQL Server 2008 R2. Will upgrading to recent version of SQL Compare resolve this one? Please let us know -
System.Exception: Failed to register databases. ---> System.Data.SqlClient.SqlException: 'PowerSum' is not a recognized built-in function name.
C:\\Builds\\171\\XGS-SDI\\SCO_Mainline\\BuildType\\TFSBuild.proj(414,5): error MSB4018: Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.