sp3 vs sp3a

• potucekj

  Default port

  Points: 1414

  More actions

  June 24, 2004 at 8:02 am

  #163906

  When I do the following query I get these results:

  SELECT @@VERSION

  Output:

  Microsoft SQL Server 2000 - 8.00.760 (Intel X86)

  Dec 17 2002 14:22:05

  Copyright (c) 1988-2003 Microsoft Corporation

  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

  How can I determine if this is SP3 or SP3A????

• Derrick Leggett

  SSCrazy

  Points: 2778

  More actions

  June 24, 2004 at 9:05 pm

  #511895

  Version Number	Service Pack
  8.00.194	Microsoft SQL Server 2000
  8.00.384	Microsoft SQL Server 2000 SP1
  8.00.532	Microsoft SQL Server 2000 SP2
  8.00.760	Microsoft SQL Server 2000 SP3
  8.00.818	Microsoft SQL Server 2000 SP3 w/ Cumulative Patch MS03-031

  Derrick Leggett
  Mean Old DBA
  When life gives you a lemon, fire the DBA.

• Julian Kuiters

  SSCertifiable

  Points: 6585

  More actions

  June 25, 2004 at 12:29 am

  #511909

  mmm Microsoft must have forgotten to increase the build number for SP3a, despite some of the added fixes, SP3 and SP3a report the same version (8.00.760). The only way to tell is by checking a number of .DLL's on the hard disk.

  The following table lists the Sqlservr.exe version number:

  Release	Sqlservr.exe
  RTM	2000.80.194.0
  SQL Server 2000 SP1	2000.80.384.0
  SQL Server 2000 SP2	2000.80.534.0
  SQL Server 2000 SP3	2000.80.760.0
  SQL Server 2000 SP3a	2000.80.760.0

   

  Distinguishing Between SP3 and SP3a

  To determine whether you have SP3 or SP3a installed, look at the version number of the Net-Library file, Ssnetlib.dll. If the version number of this file is 2000.80.760.0, you have SP3; if the version number of this file is 2000.80.766.0, you have SP3a.

  Assuming that an instance was installed using the default settings, you can find the Ssnetlib.dll file in one of these locations:

  • Default instance: C:\Program Files\Microsoft SQL Server\Binn\Ssnetlib.dll
  • Named instance: C:\Program Files\Microsoft SQL Server\MSSQL$<InstanceName>\Binn\Ssnetlib.dll

  To find out whether you have the SP3 or SP3a setup folders, open the SP3Readme.htm file and read the first page. The service pack version, SP3a or SP3, is listed at the top of the first page.

  See: http://support.microsoft.com/default.aspx?scid=%2fsupport%2fServicePacks%2fSQL%2f2000%2fSP3ReadMe.asp#_identifying_the_current_version_of_sql_server_or_analysis_services

  ---

  Julian Kuiters
  juliankuiters.id.au

• potucekj

  Default port

  Points: 1414

  More actions

  June 25, 2004 at 4:21 am

  #511924

  All most helpfull !!!

  Thank you

• rcavill

  Default port

  Points: 1482

  More actions

  August 11, 2004 at 4:57 am

  #518446

  One of the things I read when SP3a first come out was that is was released due to the installation process failing when applying normal SP3 on Windows 2003 Server. Hence SP3a was released to overcome the deployment on Windows 2003 Server.

  My understanding was the contents were effectively the same, however as shown in previous post there was one file difference and a registry entry showing a different build.

  Therefore, unless your SQL2K is running on Windows 2003 Server, if it reports SP3 all would be good!

  Robert