90 compatability mode option not available after upgrade

I upgrade to sql 2005 from sql2000. The problem is that the compatability mode 90 is not available, 8.0 and 7.0 are, when looking at the compatability level in the properties tab. THe GUI, Management studio is loaded and operational.

What do I need to do to make the 90 compatability mode available?

Thanks!

You can use the following T-SQL Sentences to change to Compatibility Mode to 90 for your database.

USE [master]

GO

EXEC dbo.sp_dbcmptlevel @.dbname=N'MyDatabase', @.new_cmptlevel=90

GO

But, i'm sure that this will not work fine for you, because, i look that is possible that your database have enabled some features, that only work in the 80 compatibility mode, because this has been disabled or are obsolete in SQL Server 2005.

Best Regards,

|||

Are you sure you actually installed the 2005 database engine? It sounds as if just the client tools are installed. What version number is reported when you run the following SQL against the master database?

SELECT @.@.version