Re: sql server mess? - please help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

  • Re: Using Query Analyzer with SQL 2005
    ... to 2005) was undone for the release of SP4. ... What version of SQL Server 2000 Query Analyzer are you using? ... or will I always need to keep a copy of SQL Server 2000 to install ...
    (microsoft.public.sqlserver.tools)
  • Re: Using Query Analyzer with SQL 2005
    ... I suppose the "production" SP4 will just have to wait until I wipe ... What version of SQL Server 2000 Query Analyzer are you using? ... that comes with SQL Server 2005 that I can contiue to install on my ...
    (microsoft.public.sqlserver.tools)
  • Re: sql server mess? - please help
    ... You might have MSDE installed, and SP4 for the full product does not work on ... Mike Epprecht, Microsoft SQL Server MVP ... > I went back to query analyzer, ...
    (microsoft.public.sqlserver.setup)
  • Re: MSDE 2000 Release A - Query Analyzer included?
    ... You could download the evaluation edition of SQL Server 2000 and use those ... Mike Epprecht, Microsoft SQL Server MVP ... >I installed MSDE 2000 Release A, but can't find the Query Analyzer. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL Tools
    ... prevent the SQL Server tools from connecting to a non-SP4 SQL Server ... I want to install the SQL Tools on a server which will be used ... the same server will also have MSDE installed on it for the ... Also, if I SP4 the box, will the ...
    (microsoft.public.sqlserver.setup)