After I update the existed sql 2000 to sql 2005. But I saw the sql is still running v8.0 (

Dear All,
After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
running the 2000 core).
But I remembered that I had selected the options to upgraded the existed
SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
I saw some helps that when I setup the SQL2K5. Add one parameters when
setting up?
Thanks for your helps first,;)
Best Regards,
Benny NgHi Benny
Your databases may be in 8.0 compatability mode, but if you upgraded
correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION give?
If you look in the services applet you should see what services are running.
You should also have the SQL 2005 tools available on the start menu.
John
"Benny Ng" wrote:
> Dear All,
> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
> running the 2000 core).
> But I remembered that I had selected the options to upgraded the existed
> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
> Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
> I saw some helps that when I setup the SQL2K5. Add one parameters when
> setting up?
> Thanks for your helps first,;)
>
> Best Regards,
> Benny Ng
>
>|||Dear John Bell,
The command SELECT @.@.VERSION, After running. The result i got is
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
And surely i have the SQL2K5 tools on the start menu. The difference
between my laptop (it's normally installed SQL2K5) is only the SQL engine.
Best Regards,
Benny Ng
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
> Hi Benny
> Your databases may be in 8.0 compatability mode, but if you upgraded
> correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION
> give?
> If you look in the services applet you should see what services are
> running.
> You should also have the SQL 2005 tools available on the start menu.
> John
> "Benny Ng" wrote:
>> Dear All,
>> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
>> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
>> running the 2000 core).
>> But I remembered that I had selected the options to upgraded the
>> existed
>> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
>> Can anyone tell me how can I upgrade the existed SQL2K core to
>> SQL2K5?
>> I saw some helps that when I setup the SQL2K5. Add one parameters when
>> setting up?
>> Thanks for your helps first,;)
>>
>> Best Regards,
>> Benny Ng
>>
>>|||Perhaps you have several instances of SQL Server and you didn't upgrade the instance you are looking
at...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Benny Ng" <benny_wufree@.hotmail.com> wrote in message news:O85gxiIDHHA.628@.TK2MSFTNGP04.phx.gbl...
> Dear John Bell,
> The command SELECT @.@.VERSION, After running. The result i got is
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003
> Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
> And surely i have the SQL2K5 tools on the start menu. The difference between my laptop (it's
> normally installed SQL2K5) is only the SQL engine.
> Best Regards,
> Benny Ng
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
>> Hi Benny
>> Your databases may be in 8.0 compatability mode, but if you upgraded
>> correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION give?
>> If you look in the services applet you should see what services are running.
>> You should also have the SQL 2005 tools available on the start menu.
>> John
>> "Benny Ng" wrote:
>> Dear All,
>> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
>> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
>> running the 2000 core).
>> But I remembered that I had selected the options to upgraded the existed
>> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
>> Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
>> I saw some helps that when I setup the SQL2K5. Add one parameters when
>> setting up?
>> Thanks for your helps first,;)
>>
>> Best Regards,
>> Benny Ng
>>
>>
>|||Hi
What does the services applet show in terms of instances running? Are you
running the upgrade using the correct version of the CDs? Have you run the
latest upgrade advisor?
John
"Benny Ng" wrote:
> Dear John Bell,
> The command SELECT @.@.VERSION, After running. The result i got is
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
> And surely i have the SQL2K5 tools on the start menu. The difference
> between my laptop (it's normally installed SQL2K5) is only the SQL engine.
> Best Regards,
> Benny Ng
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
> > Hi Benny
> >
> > Your databases may be in 8.0 compatability mode, but if you upgraded
> > correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION
> > give?
> >
> > If you look in the services applet you should see what services are
> > running.
> > You should also have the SQL 2005 tools available on the start menu.
> >
> > John
> >
> > "Benny Ng" wrote:
> >
> >> Dear All,
> >>
> >> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
> >> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
> >> running the 2000 core).
> >>
> >> But I remembered that I had selected the options to upgraded the
> >> existed
> >> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
> >>
> >> Can anyone tell me how can I upgrade the existed SQL2K core to
> >> SQL2K5?
> >> I saw some helps that when I setup the SQL2K5. Add one parameters when
> >> setting up?
> >>
> >> Thanks for your helps first,;)
> >>
> >>
> >> Best Regards,
> >>
> >> Benny Ng
> >>
> >>
> >>
> >>
>
>