Re: SQL Patch not working on Professional

From: Mike (mvalencia@tier3support.com)
Date: 01/29/03 

From: "Mike" <mvalencia@tier3support.com>
Date: Tue, 28 Jan 2003 17:52:33 -0800

Which would be the correct patch then?

>-----Original Message-----
>ignore the version number in the second one. It should
say 8.00.760 not
>8.00.194
>
>--
>Richard Waymire, MCSE, MCDBA
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Richard Waymire [MS]" <rwaymi@online.microsoft.com>
wrote in message
>news:eM8rMbwxCHA.1296@TK2MSFTNGP11...
>> Not sure I understand your question 100%.
>>
>> To verify the engine version you should log in and
run "select @@version"
>>
>> or run
>>
>> osql.exe -E -Q"select @@version" -Syourservername
>>
>> If that's not
>>
>> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Developer Edition on Windows NT 5.1 (Build 2600:
Service Pack 1)
>>
>>
>> (1 row(s) affected)
>>
>>
>> Then it needs to be updated. Notice on the last line
mine says I'm
>running
>> the developer edition of SQL Server. If you see
>>
>> Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
>> Aug 6 2000 00:57:48
>> Copyright (c) 1988-2000 Microsoft Corporation
>> Desktop Engine on Windows NT 5.1 (Build 2600: Service
Pack 1)
>>
>>
>> Then you have MSDE and need to download the MSDE patch.
>>
>> --
>> Richard Waymire, MCSE, MCDBA
>>
>> This posting is provided "AS IS" with no warranties,
and confers no
>rights.
>> "mike" <mvalencia@tier3support.com> wrote in message
>> news:00c601c2c704$7773ce70$d6f82ecf@TK2MSFTNGXA13...
>> > If the user has the SP3 in the systray running and
you run
>> > the information saying system info the version shows
SQL
>> > 8.00.194 but I feel it may be MSDE 2.0 which patch
would
>> > be needed for this?
>> >
>> > >-----Original Message-----
>> > >What edition of SQL Server and which SP3 are you
using?
>> > I've also seen this
>> > >message when running the regular SP3 against an
instance
>> > of MSDE - you need
>> > >the specific SP3 for MSDE as MSDE uses a different
setup
>> > technology than SQL
>> > >Server if that's the case...
>> > >
>> > >--
>> > >Richard Waymire, MCSE, MCDBA
>> > >
>> > >This posting is provided "AS IS" with no warranties,
and
>> > confers no rights.
>> > >"Mike" <mvalencia@tier3support.com> wrote in message
>> > >news:01a101c2c6f8$8ade03b0$d3f82ecf@TK2MSFTNGXA10...
>> > >> "SQL Server 2000 is not installed on this machine.
>> > Setup
>> > >> will now exit."
>> > >>
>> > >> Even though the SQL 2000 Server is running
>> > >>
>> > >> version 8.00.194
>> > >>
>> > >>
>> > >> >-----Original Message-----
>> > >> >no, it shoud work fine - what's the error message
being
>> > >> returned?
>> > >> >
>> > >> >--
>> > >> >Richard Waymire, MCSE, MCDBA
>> > >> >
>> > >> >This posting is provided "AS IS" with no
warranties,
>> > and
>> > >> confers no rights.
>> > >> >"Mike" <mvalencia@tier3supportt.com> wrote in
message
>> > >> >news:06bc01c2c6f1$b6341600
$8af82ecf@TK2MSFTNGXA03...
>> > >> >> Is there a reason a customer cannot run the SP3
SQL
>> > >> patch
>> > >> >> on a Win2K professional environment.
>> > >> >
>> > >> >
>> > >> >.
>> > >> >
>> > >
>> > >
>> > >.
>> > >
>>
>>
>
>
>.
>

Relevant Pages