no compatibilty mode 90 option in SQL 2005 ?????

[winsys]

I ran the SQL 2005 setup on my SQL 2000 server.

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?

Also, SQL 2000 is still running and I'm still able to view the datababses in Enterprise Manager. I guess SQL 2005 doesn't remove the SQL 2000 install?

 

[SQLDenis]

try running
sp_dbcmptlevel 'DatabaseName',90

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[winsys]

Thanks for the quick reply Denis.

Should I run this "sp_dbcmptlevel 'DatabaseName',90" for each of the system and user databases?

Thanks,
Mark

 

[mrdenny]

You have to set the compability mode for each databases so yeah, you'll need to run it for each database.

When you installed SQL 2005 did you do an upgrade, or did you install to a new instance? If SQL 2000 is still running it sounds like you installed a new instance instead of doing an upgrade.

If you did an upgrade then SQL 2000 would have been uninstalled, as would the SQL 2000 Client Tools.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com