Re: Version # and Service Patch

From: Sebastian K. Zaklada (szaklada-dont-like-spam_at_skilledsoftware.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 11:11:43 +0100

FROP wrote:
> So there's no way to differentiate between SP3 and SP3a?

For SP3 and SP3a @@VERSION returns 8.00.760 and SELECT
SERVERPROPERTY('ProductLevel') a product level of SP3

See SP3 readme
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp

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.

sincerely, 

--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

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)
  • SQL SP3 problems fixed with SP3a
    ... I was running SBS2K with SQL SP3 ... there's no need to apply SP3a. ... SQL would use up all my available memory. ...
    (microsoft.public.backoffice.smallbiz2000)
  • 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: sms 2003 sp2 requirements - sql 3a
    ... Check out the SMS Technical FAQ: ... This posting is provided AS IS with no warranties and confers no rights. ... does not distinguish between SP3 and SP3a. ...
    (microsoft.public.sms.setup)
Loading