Yesterday evening, I was working on moving an old database from MS SQL Server 7.0 to a new server running MS SQL Server 2005.  Using SQL 2005 Management Studio, the moved database just stated "Database Name" (6.5 Compatibility).

After a few google searches, I found this site describing the same problem.  To correct the problem and convert the old database to SQL Server 2005 format, you would issue the following SQL command:

EXEC sp_dbcmptlevel 'MyDBName', '90';


I learned another fact last night about SQL 2005. SQL Enterprise manager, which was in SQL 2000 and SQL 7.0, is now called Management Studio. And the query analyzer, which used to be a separate application, is now incorporated inside SQL 2005 Management Studio.

--Chris