Knowledgebase & FAQ |
How do I change compatibility levels on Microsoft SQL Server 6.5, 7 and 2000?Symptom In various functions through-out the product (primarily when running reports), you may receive SQL Syntax errors.
Cause There are a number of SQL syntax differences between Microsoft SQL Server 6.5, 7 and 2000. RecFind supports Microsoft SQL Server 7 and 2000, however despite using one of these versions your database may only accept SQL Server 6.5 syntax. This is due to the database compatibility level setting of your database. This normally occurs if you have upgraded from Microsoft SQL Server 6.5 to 7 or 2000. Your database may be configured to act as a version 6.5 database and therefore not support the SQL syntax used by RecFind. Solution To check your database compatibility level, run the following statement via SQL Query Analyser:
sp_dbcmptlevel RecFind Note: change 'RecFind' to be the name of the SQL database used for RecFind If you are using MS SQL Server v7.0, please ensure that the above statement returns 70, if not please run the following statement: sp_dbcmptlevel RecFind,70 Note: change 'RecFind' to be the name of the SQL database used for RecFind If you are using MS SQL Server v2000, please ensure that the above statement returns 80, if not please run the following statement: sp_dbcmptlevel RecFind, 80 Note: change 'RecFind' to be the name of the SQL database used for RecFind
|