on 06-24-2009 9:45 PM
Hi,
I am in the process of testing the upgrade. Re to the Upgrade guide I installed SQL Server 2005. The guide then tells me to change the Compatibility Level of the company databases to 90. When I look at the properties this value is not in the list (only 70 and 80). Is this an issue?
Do I have to convert the databases in any regard or do they just stay as is?
Thanks Olaf
Hi Olaf,
Where did you check this Compatibility Level, in 2000 or 2005? Only SQL Server 2005 has the option for 90.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Olaf,
Following your description I did exactly what you did. I want to highlight that on my installation the values 90, 80 and 70 exist.
I guess you might have upgraded Enterprise Manager to SQL Management Studio only, but not the database engine itself.
Using Management Studio and connect to your DB's
Tn the left hand side there should be a structure like:
-Servername (some numbers)
+Databases
Let us know the exact numbers for "(some numbers)"
Further help how to identify your running MSSQL Server installation you'll find at [http://support.microsoft.com/kb/321185|http://support.microsoft.com/kb/321185]
Kind regards
Mario
User | Count |
---|---|
90 | |
9 | |
6 | |
6 | |
4 | |
3 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.