Re: File Protection

From: Jeff (jeff_nospam_at_eNetPortals.com)
Date: 11/04/04 

Date: Thu, 04 Nov 2004 19:47:22 GMT

Hi Michael -

As far as I've been able to determine, I have been installing SP3a. From
the sp3readme.htm that comes with the download:

"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."

My ssnetlib.dll version is 2000.80.766.0.

What was it about what I posted that appeared to be SP3 (not SP3a)?? Is the
above "test" not correct? Am I misinterpreting something?

- Jeff

""Michael Cheng [MSFT]"" <v-mingqc@online.microsoft.com> wrote in message
news:PzVV$qjwEHA.3028@cpmsftngxa10.phx.gbl...
> Hi Jeff,
>
> Thanks for your prompt reply and detailed explanation!
>
> I began to understand your concerns.
>
> First of all, we could find the descriptions like below in redist.txt
>
> SQLREDIS.EXE
> ----------------------------------------------------------------------
> This package contains the following redistributable components:
> ----------------------------------------------------------------------
> Jet 4.0
> Jet OLE DB 4.0
> ODBC Driver for Desktop Databases
> SQL Server 2000 Network Libraries
> SQL ODBC drivers
> SQL OLEDB provider
> SQL XML provider
> Microsoft Data Access Components (MDAC) version 2.6
>
> As the file named, sqlredis.exe will install some component needed by SQL
> Server Setup. dahotfix.exe is just a hotfix for MDAC.
>
> Secondly, as I have said, sqlredis.exe will be a silent installation and
it
> will also not do any harm the system. For example, for those had MDAC 2.8
> installed, sqlredis.exe will skip MDAC 2.6 installtion as expected. The
> reason why I perfer dahotfix.exe alone was that I can not guarantee what
> would happened in the target server and everything might happened, right?
> (For example, customer delete a critial file by fault or he modified
> internal codes of that file) However, please feel free to running
> sqlredis.exe, according to my survey on newsgroup and SQL cases, there are
> no related issues caused by running sqlredis.exe
>
> Last but not least, I would love to whether SQL Server SP3a will resolve
> your problem.
>
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
>
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---------------------------------------------------------------
> Get Secure! - http://www.microsoft.com/security
>
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

Relevant Pages

  • 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: 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: Win2k SP4
    ... Its hard too tell after 2 days but installing it on our test server, ... SQL, TS,IS,IIS a DC and FS and had no problems from the service pack. ... > too many negatives I read on the various forums regarding SP3. ...
    (microsoft.public.win2000.security)