Re: What's the real difference between SP3 and SP3a?

From: rskohman (rskohman_at_hewitt.com)
Date: 08/04/03

  • Next message: (no email): "lock to table" 
    Date: Mon, 4 Aug 2003 14:46:29 -0700

    Thank you for your prompt response Dinesh!
    I greatly appreciate it

    >-----Original Message-----
    >Rskohman,
    >
    >Differences are there but the issues addressed for SP3a
    were in setup,
    >client components, and the Net-Libraries and not in the
    database engine.
    >Since the database engine remains the same, there wont be
    any benefits
    >installing it if you are already on SP3.The engine was
    not rebuilt for SP3a
    >and thus the versions are the same as they were for
    SP3.The three fixes made
    >in sp3a(http://support.microsoft.com/?kbid=306908) are
    related to sql server
    >setup and thus there isnt any need to apply sp3a to a
    existing sql
    >server2000 sp3, as in your case. Its is only recommended
    if you have
    >instances that have not yet been upgraded to SP3, in that
    case you should
    >always upgrade those instances directly to SP3a instead
    of SP3.
    >
    >
    >--
    >Dinesh.
    >SQL Server FAQ at
    >http://www.tkdinesh.com
    >
    >"rskohman" <rskohman@hewitt.com> wrote in message
    >news:02fb01c35acc$474d1c90$a601280a@phx.gbl...
    >> I have many servers (60ish) that have SP3 installed.
    Since
    >> we have to apply the latest hotfix anyway, is there
    >> anything to be gained by applying SP3a to all the
    servers
    >> that have SP3? I know MS says you don't *HAVE* to apply
    >> SP3a to any server that already has SP3. But if there
    >> wasn't any difference between the two then why release
    3a?
    >> Any help would be appreciated. Thanks!
    >
    >
    >.
    >

  • Next message: (no email): "lock to table"

    Relevant Pages

    • Re: telling difference between SP3 and SP3a
      ... The differences between SP3 and SP3a do not make a difference in the ... product/engine etc. ... The newer release has an updated setup (which only ...
      (microsoft.public.sqlserver.server)
    • RE: Identifying the SP3 and SP3a
      ... Mike Epprecht, Microsoft SQL Server MVP ... > I want to identify the machines installed with SP3 and SP3a, ... > of SP3a says the above can be done by looking at the version of Ssnetlib.dll ... > in the default folder of SQL installation. ...
      (microsoft.public.sqlserver.setup)
    • Re: SQL 2k Version
      ... means your sql server 2000 is running with SP3. ... But most changes introduced in SP3a are related to Setup, ... > I was wondering is this the latest version of the Dev edition ...
      (microsoft.public.sqlserver.server)
    • Re: Can I install SP3a over the existing SP3?
      ... You can very well install SP3a over SP3 in SQL Server ... If it is production system it is always recommended to apply the SP3a above ... SP3 in test server, test it for couple of days and apply to production. ...
      (microsoft.public.sqlserver.setup)
    • Re: Service Pack 3a
      ... sp3a has no fixes specific to replication which weren't in sp3 (see ... issues addressed for SP3a were in setup, client components, and the ... recall it is no longer possible to download sp3 and the general advice is ...
      (microsoft.public.sqlserver.replication)