No compatibilty level 90 option after upgrade from SQL 2000 to 2005

I did an in place upgrade of my SQL 2000 server to SQL 2005.

Now all the system and user databases are set to compatibilty mode 80 and in the options tab there is no compatibilty mode 90 option.

How can I set the databasbes to compatibility mode 90?

Thanks!

Stange thing, did you try using the TSQL command for that ?

sp_dbcmptlevel [ [ @.dbname = ] name ]
[ , [ @.new_cmptlevel = ] version ]
90 = SQL Server 2005

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

NIC Teaming ( Fault Tolerant Mode)

Has anyone had good or bad experiences with enabling NIC Teaming ..i.e. the
redundant method for your SQL Servers ? Any issues to be concerned with ?
Would like to hear from youll
ThanksGenerally, I haven't had/heard any problems. SQL Product Support Services
(PSS) may ask you to disable it as a troubleshooting step, especially in a
clustered environment if you open a support case, but otherwise I am unaware
of any concerns.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:unCY6rM3EHA.524@.TK2MSFTNGP09.phx.gbl...
> Has anyone had good or bad experiences with enabling NIC Teaming ..i.e.
the
> redundant method for your SQL Servers ? Any issues to be concerned with ?
> Would like to hear from youll
> Thanks
>

NIC Teaming ( Fault Tolerant Mode)

Has anyone had good or bad experiences with enabling NIC Teaming ..i.e. the
redundant method for your SQL Servers ? Any issues to be concerned with ?
Would like to hear from youll
Thanks
Generally, I haven't had/heard any problems. SQL Product Support Services
(PSS) may ask you to disable it as a troubleshooting step, especially in a
clustered environment if you open a support case, but otherwise I am unaware
of any concerns.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:unCY6rM3EHA.524@.TK2MSFTNGP09.phx.gbl...
> Has anyone had good or bad experiences with enabling NIC Teaming ..i.e.
the
> redundant method for your SQL Servers ? Any issues to be concerned with ?
> Would like to hear from youll
> Thanks
>