When tried to run the TSQL analyzer on SQL server 2008 participating DB during analysis, Error Message : "database compatibility level value differs from the one of the current server(expected value= 90)".
Also Database Compatibility level is 100 by default.
Release | Yes/No |
|---|---|
| 7.2.x |  |
| 7.0.x |  |
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
| CSS1 | |
Participating databases, hosted on a Microsoft SQL Server 2008, are supported by the TSQL Analyzer on condition that there is only
TSQL 2005 (or lower) on it. That's why this message is displayed requiring that your database's Compatibility level must be set to 90 (MSQL 2005).
This point is explained in the "Supported Languages" part of the documentation 7.0 at paragraph "Microsoft T-SQL".
Actually the only way know to analyze your participating is to set it's compatibility level to 90.
On can do the same by following below steps:
Microsoft SQL Server Management Studio > Database Properties > Options > Compatibility Level
Change "SQL Server 2008(100)" to "SQL Server 2005(90)"
NOTE: From Cast 7.0.7 onwards, T-SQL Analyzer supports Microsoft SQL Server 2008