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
No comments:
Post a Comment