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
» Back to FAQ index
