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

Back to FAQ index

 

  Back | Top
Site by Intelliweb Productions