Need here:

Upgrading from 2000 to 2005 and applying SP2 ran well. But the
instance and databases are still showing version 8, not 9, even though
the EM is 2005.

Any comments are appreciated!

Still showing version 8... WHERE???


On 5/16/08 4:22 PM, in article
73434e62-43c2-4144-84e1-f55fd67b8004...oglegroups.com, "JohnDo3"
<schen3838@gmail.com> wrote:

> Need here:
>
> Upgrading from 2000 to 2005 and applying SP2 ran well. But the
> instance and databases are still showing version 8, not 9, even though
> the EM is 2005.
>
> Any comments are appreciated!

JohnDo3

The instance shows version 8!?! That is surprising and suggests that you are
not connecting to the SQL Server 2005 instance.

Databases show version 8? Do you mean that they are set to Compatibility
Level 80? If so, they simply ALTER the databases to the proper
compatibility level. (But first make sure that you connected to the SS2005
instance.)

If by EM you mean Enterprise Manager, called SQL Server Management Studio in
SS2005, it can connect to older versions of SQL Server as well.

RLF

"JohnDo3" <schen3838@gmail.com> wrote in message
news:73434e62-43c2-4144-84e1-f55fd67b8004@e53g2000hsa.googlegroups.com...
> Need here:
>
> Upgrading from 2000 to 2005 and applying SP2 ran well. But the
> instance and databases are still showing version 8, not 9, even though
> the EM is 2005.
>
> Any comments are appreciated!

On May 16, 4:44 pm, "Russell Fields" <russellfie...@nomail.com> wrote:
> JohnDo3
>
> The instance shows version 8!?! That is surprising and suggests that you are
> not connecting to the SQL Server 2005 instance.
>
> Databases show version 8? Do you mean that they are set to Compatibility
> Level 80? If so, they simply ALTER the databases to the proper
> compatibility level. (But first make sure that you connected to the SS2005
> instance.)
>
> If by EM you mean Enterprise Manager, called SQL Server Management Studio in
> SS2005, it can connect to older versions of SQL Server as well.
>
> RLF
>
> "JohnDo3" <schen3...@gmail.com> wrote in message
>
> news:73434e62-43c2-4144-84e1-f55fd67b8004@e53g2000hsa.googlegroups.com...
>
> > Need here:
>
> > Upgrading from 2000 to 2005 and applying SP2 ran well. But the
> > instance and databases are still showing version 8, not 9, even though
> > the EM is 2005.
>
> > Any comments are appreciated!

Would that mean upgrade is not complete? Could re-do the upgrade
work?

> Would that mean upgrade is not complete? Could re-do the upgrade
> work?

We still don't understand what you are talking about. Where/what shows
"version 8"? Could you be a bit more specific?

"JohnDo3" <schen3838@gmail.com> wrote in message
news:59c1e36e-43e6-4043-80bf-5fa60a4bbac5@d77g2000hsb.googlegroups.com...
> On May 16, 4:44 pm, "Russell Fields" <russellfie...@nomail.com> wrote:
>> JohnDo3
>>
>> The instance shows version 8!?! That is surprising and suggests that you
>> are
>> not connecting to the SQL Server 2005 instance.
>>
>> Databases show version 8? Do you mean that they are set to Compatibility
>> Level 80? If so, they simply ALTER the databases to the proper
>> compatibility level. (But first make sure that you connected to the
>> SS2005
>> instance.)
>>
>> If by EM you mean Enterprise Manager, called SQL Server Management Studio
>> in
>> SS2005, it can connect to older versions of SQL Server as well.
>>
>> RLF
>>
>> "JohnDo3" <schen3...@gmail.com> wrote in message
>>
>> news:73434e62-43c2-4144-84e1-f55fd67b8004@e53g2000hsa.googlegroups.com...
>>
>> > Need here:
>>
>> > Upgrading from 2000 to 2005 and applying SP2 ran well. But the
>> > instance and databases are still showing version 8, not 9, even though
>> > the EM is 2005.
>>
>> > Any comments are appreciated!
>
> Would that mean upgrade is not complete? Could re-do the upgrade
> work?

Everyone is guessing here because you haven't given enough details. In a
query window run the query

SELECT @@VERSION

or you can also run

SELECT SERVERPROPERTY('ProductVersion')

If you talking about the compatibility level for the database, you can use

EXEC sp_dbcmptlevel @dbname = '<database name>'

and enter the <database name> you want to test. To change the compatibility
level use:

EXEC sp_dbcmptlevel @dbname = '<database name>' , @new_cmptlevel = 90

I assume you ran the upgrade advisor before upgrading to make sure your
database were compliant?

John

My guess is you think you upgraded your SQL Server 2000 instance to a SQL
Server 2005 instance but I think you just installed another instance of SQL
Server.

So, you must have at least two instances of SQL Server installed on your
server now. One of them is your old SQL Server 2000 instance which was
supposed to be upgraded to 2005 and the other is the new SQL Server 2005.

And as Russell comments, you must be connecting to your old 2000 instance.

You better run MMC and search for your installed SQL Server services.

--
Ekrem Önsoy



"JohnDo3" <schen3838@gmail.com> wrote in message
news:59c1e36e-43e6-4043-80bf-5fa60a4bbac5@d77g2000hsb.googlegroups.com...
> On May 16, 4:44 pm, "Russell Fields" <russellfie...@nomail.com> wrote:
>> JohnDo3
>>
>> The instance shows version 8!?! That is surprising and suggests that you
>> are
>> not connecting to the SQL Server 2005 instance.
>>
>> Databases show version 8? Do you mean that they are set to Compatibility
>> Level 80? If so, they simply ALTER the databases to the proper
>> compatibility level. (But first make sure that you connected to the
>> SS2005
>> instance.)
>>
>> If by EM you mean Enterprise Manager, called SQL Server Management Studio
>> in
>> SS2005, it can connect to older versions of SQL Server as well.
>>
>> RLF
>>
>> "JohnDo3" <schen3...@gmail.com> wrote in message
>>
>> news:73434e62-43c2-4144-84e1-f55fd67b8004@e53g2000hsa.googlegroups.com...
>>
>> > Need here:
>>
>> > Upgrading from 2000 to 2005 and applying SP2 ran well. But the
>> > instance and databases are still showing version 8, not 9, even though
>> > the EM is 2005.
>>
>> > Any comments are appreciated!
>
> Would that mean upgrade is not complete? Could re-do the upgrade
> work?