Results 1 to 4 of 4

Thread: service pack

  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: service pack

    hi,
    How can i know what service pack is install on my db, SP3 or SP3a.
    When i check the properties on the db there is SP3.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    I'm not sure of the functional differences between SP3 and SP3a; at one time I may have know, but I have forgotten it. My SQL 2000 to which I know that I applied SP3a also says SP3 on the properties page.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Feb 2004
    Posts
    492
    Perhaps SELECT SERVERPROPERTY('ProductLevel') gives a distinction? Not sure, can't try.

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    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
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •