Re: sp3 vs sp3a

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/02/04


Date: Tue, 02 Mar 2004 08:23:36 -0700

What Kevin outlined are the differences between 3 and 3a
1. 3a can be applied to trial versions
2. 3a includes MDAC 2.71a which fixed the memory leak issue
3. 3a disables listening on UDP 1434 when all libraries
except for shared memory are disabled.
SP 3 doesn't include those three fixes.

-Sue

On Tue, 2 Mar 2004 06:56:32 -0800,
<anonymous@discussions.microsoft.com> wrote:

>Thanks for your response; but, I wanted to know the
>difference between sp3 and sp3a. I have already
>researched the service packs and the applicable changes
>that the service pack does. I want to know why MS
>created a distinction between "sp3" and "sp3a." Really I
>just want to know the difference between the two. I
>already know that there are no file changes. So why
>the "alpha" version?
>>-----Original Message-----
>>
>>Improves serviceability for SQL Server 2000 Evaluation
>Edition. SP3a
>>enables service pack upgrades for trial software. In the
>past, service
>>packs have not been applicable to trial software.
>>Includes a new version of Microsoft Data Access
>Components (MDAC) version
>>2.71a. This version fixes the installation of MDAC files
>and a memory leak.
>>These issues are addressed in articles 814572 and 814410
>in the Microsoft
>>Knowledge Base.
>>Disables listening on port 1434 when networking is
>disabled. This provides
>>further protection from "denial of service" attacks.
>>
>>
>>You can view the webcast from the following location;
>>
>>822144 Support WebCast: Microsoft SQL Server 2000 SP 3a:
>What It Is, Why It
>>Is,
>>http://support.microsoft.com/?id=822144
>>
>>
>>Thanks,
>>
>>Kevin McDonnell
>>Microsoft Corporation
>>
>>This posting is provided AS IS with no warranties, and
>confers no rights.
>>
>>
>>
>>.
>>



Relevant Pages

  • Re: Physical Memory Dump
    ... >Beginning Dump of Physical Memory and a clock that clicks off seconds. ... try updating the drivers for the new hardware, ... Have you tried upgrading to Service Pack 2? ... In memory of a dear friend Alex Nichol MVP ...
    (microsoft.public.windowsxp.general)
  • Re: sp3a upgrade to developer edition
    ... You will need to run the service pack for all instances of SQL Server ... running and at a guess your Developer Edition is not the default instance. ... I believe the highest version of MDAC is 2.8. ... special upgrade for the DE? ...
    (microsoft.public.sqlserver.server)
  • Re: VS2005 IDE Crawls
    ... The service pack addressed some performance issues with Visual Studio, ... Robin S. ... I second RobinS' suggestion to get 2 gig of memory. ... Get a 2 gig kit. ...
    (microsoft.public.dotnet.general)
  • RE: ODBC & SQLExecDirect
    ... There is a KB article that says that there is a bug in MDAC 2.6 and you ... The Service Pack for MDAC 2.6 can be obtained from ... Please apply latest service pack for SQL Server 2000, SP3, if you have not ...
    (microsoft.public.sqlserver.programming)
  • RE: ODBC & SQLExecDirect
    ... We have MDAC 2.8 installed with service pack 3a. ... >Please apply latest service pack for SQL Server 2000, ... SP3, if you have not ...
    (microsoft.public.sqlserver.programming)