SUPPORT: Problems Installing Database on SQL 2005

[Alan Ranciato]

ISSUE:

When running the installation process on a SQL2005 database, you encounter the error:

Quote:

ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator. ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.

ANALYSIS/Resolution:

It happens that SQL2005 validates database scripts a little differently than SQL2K and is a little pickier. There are two script files that contain a definition for a deprecated stored procedure. You can either remove the procedure manually from the files or replace the files with the two attached files.

The script files are located in <webroot>\BlueWhaleCRMAdmin\scripts

and are:

* version-2.0.1.sql
* version-1.0.1.1.sql

The procedure to remove is: GetMessageCounts - it is located in both of the above listed files.

You can either start the DB creation from scratch on a clean database, or, if after replacing these files, you can just log back into the Admin client and selected "upgrade" from the menu list. This will allow you to pick up from where you left off.