Re: sql server mess? - please help

Hi

What does all of it say?

Mine says:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)

Also

SELECT SERVERPROPERTY('Edition')

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Carlos" <ch_sanin@xxxxxxxxx> wrote in message
news:OemvjnHlFHA.3148@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks Mike. It says 8.00.534
>
> "Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx> wrote in message
> news:ugfyMQHlFHA.2608@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi
>> You might have MSDE installed, and SP4 for the full product does not work
>> on MSDE. MSDE has it's own SP.
>>
>> What does SELECT @@VERSION say what edition you are running?
>>
>> Regards
>> --------------------------------
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>>
>> IM: mike@xxxxxxxxxxxx
>>
>> MVP Program: http://www.microsoft.com/mvp
>>
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Carlos" <ch_sanin@xxxxxxxxx> wrote in message
>> news:Opnt2sGlFHA.1416@xxxxxxxxxxxxxxxxxxxxxxx
>>> Hi all,
>>>
>>> I have been having a connectivity problem with my local instance
>>> of sql server. It says that the connection to the server has been
>>> broken.
>>> I ran 'select @@version', and found out that I was running version
>>> 8.00.534 (i.e. SP2). I then downloaded SP4, and installed it.
>>> I went back to query analyzer, and had the same problem.
>>> The DB-Library Options tab for the Client Network Utility says
>>> that I am running version 8.00.2039, the version that I query from
>>> query analyzer still says that I have version 8.00.534 even though the
>>> installation for sp4 finished successfully. How can I clean up this
>>> mess?
>>>
>>> Thanks in advance.
>>>
>>> Carlos
>>>
>>>
>>
>>
>
>


.

Relevant Pages