SQL SP3 problems fixed with SP3a

From: Wayne (anonymous_at_discussions.microsoft.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 13:52:58 -0800

Forgive me if this is old news...

I was running SBS2K with SQL SP3

When looking over the instructions for SP3a, it says if
I've already got SP3... there's no need to apply SP3a.
Silly me, I took this advice at stayed at SP3.

About every 2 weeks, I'd need to re-boot the server cause
SQL would use up all my available memory.
****************************************************

Now I'm running SBS2K3 Premimum and it was shipped with
SQL SP3a. Which I installed.

Funny thing, now my SQL memory problems are gone. No more
memory leak...

Relevant Pages

  • Re: File Protection
    ... As far as I've been able to determine, I have been installing SP3a. ... "Distinguishing Between SP3 and SP3a ... "Named instance: C:\Program Files\Microsoft SQL ...
    (microsoft.public.sqlserver.setup)
  • Re: SP3 and SQL Server Tools Installation
    ... I have run the patch but the instance does not show up ... We have, under the direction of the Macola ERP (SQL Server / Exact), ... the sp3 for the SQL Server) on any of these machines. ... these machine never see sp3a as there is no need to put the Desktop Engine ...
    (microsoft.public.sqlserver.security)
  • Re: Version # and Service Patch
    ... SERVERPROPERTYa product level of SP3 ... Distinguishing Between SP3 and SP3a ... Named instance: C:\Program Files\Microsoft SQL ...
    (microsoft.public.sqlserver.server)
  • Re: Do I have sp3a o sp3 installed on my SQL 2000?
    ... installation of the default instance; that's a mistake in the SP3a readme ... SQL Server MVP ... > To determine whether you have SP3 or SP3a installed, ...
    (microsoft.public.sqlserver.setup)
  • Re: WwK3 cluster + MSSQL sp3a upg.
    ... you need to get SP3a on your SQL for it to be supported on Windows ... security template that does not lock it down as much. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)