No database objects are visible for databases using compatibility level 70

Category: Troubleshooting & error messages
Date: 26 Nov 2008
Product: SQL Doc
SQL Doc allows you to choose a database to document, and optionally all of the objects in the database. When "compatibility mode" is set on a database, no objects may be available to document in SQL Doc.

SQL Doc is compatible with SQL Server 2000 and SQL Server 2005. Even if your database is hosted on one of these platforms, however, the database itself can still be made to be backwards-compatible with earlier versions of SQL Server. If you have come across a circumstance where you have expanded your database to show all objects in SQL Doc and no objects are available for that database, it may be because the database is set to be backwards-compatible with a version of SQL Server that is not supported by SQL Doc.

For example, if you have a database called MyDatabase, and objects for that database are not visible in SQL Doc, the first step into figuring out why would be to run this query in Query Analyzer or SQL Server Management Studio query window:

SELECT cmptlevel FROM [master]..sysdatabases WHERE [name]='MyDatabase'

If the result is a number less than '80', then the database cannot be documented by SQL Doc. Changing the compatibility level to '80' could allow SQL Doc to work with this database, however bear in mind that some legacy applications that use this database could be negatively affected. One possible workaround could be to take a backup of this database and restore it to an 'offline' server and attempt the upgrade there, if no applications will be using the database from this second server.

EXEC sp_dbcmptlevel MyDatabase, 80

Document ID: KB200805000254 Keywords: SQL,Doc,compatibility,70,no,objects

Was this article helpful?

Search support