Re: upgrading to SQL Server SP4

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

good point.

Thanks, Brad
"Dave Stoecker" <david_stoecker@xxxxxxxxxxxxxxxxx> wrote in message
news:uz5uteQOIHA.5720@xxxxxxxxxxxxxxxxxxxxxxx

"Brad Pears" <bradp@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23pllZ7POIHA.5400@xxxxxxxxxxxxxxxxxxxxxxx
I am looking at installing SP4 for our instance of SQL Server 2000
installed on our SBS.

Upgrading the Analysis services to SP4 is a completely separate download.
We do not use analysis services at all. WOuld you recommend that I
install SP4 for it as well or is it not a big deal to have the SQL db at
SP4 and leave analysis services where it is?

Thanks, Brad


If you aren't using AS, my personal viewpoint is that I would uninstall it
from the server. One less security concern...

DS



.

Relevant Pages

  • Re: Analysis Server 2000 Tuning
    ... SQL BI Product Unit (Analysis Services) ... > Microsoft Windows 2000 Advanced Server SP4 ... I have tried ADODB recordsets, ADOMD cellsets, and now we are ...
    (microsoft.public.sqlserver.olap)
  • Re: upgrading to SQL Server SP4
    ... Upgrading the Analysis services to SP4 is a completely separate download. ... WOuld you recommend that I install ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: msmdsrv.exe takes more than 95% cpu
    ... msmdsrv going into a high CPU loop when the lazy aggregator is running (i.e. ... someone kicked off a changing dimension incremental process and the flex ... SQL BI Product Unit (Analysis Services) ... I thought SP4 could correct the problem but it did not. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: msmdsrv.exe takes more than 95% cpu
    ... I had the same problem albiet under Windows XP. ... >> running (i.e. someone kicked off a changing dimension incremental process ... >> SQL BI Product Unit (Analysis Services) ... I thought SP4 could correct the problem but it did not. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Can I install Analysis Services on MS SQL 2000 Server sp4?
    ... The service pack cannot be used to install the product. ... to patch an existing installation. ... I have MS SQL Server 2000, Product version 8.00.2039, SP4, Standard edition, ... Can i install only Analysis Services SP4 package, or have I install AS from ...
    (microsoft.public.sqlserver.setup)