Loading ...
Sorry, an error occurred while loading the content.
 

Do I have SP3 or SP3a?

Expand Messages
  • bhavesh prajapati
    Do I have SP3 or SP3a? If you issue a command select @@version and If you visit following microsoft page it will say for both SP3 and SP3a the version is same
    Message 1 of 2 , Oct 1, 2007
      Do I have SP3 or SP3a?

      If you issue a command select @@version and If you visit following microsoft page it will say for both SP3 and SP3a the version is same as 2000.80.760.0.

      http://support.microsoft.com/kb/321185

      Now to determine whether you have SP3 or SP3a installed, you have to go to the BINN folder of your SQL Server installation and find the DLL file called "Ssnetlib.dll". Right Click --> Properties --> Version

      If version is
      2000.80.760.0, you have SP3
      2000.80.766.0, you have SP3a



      ---------------------------------
      Now you can chat without downloading messenger. Click here to know how.

      [Non-text portions of this message have been removed]
    • satyaskj
      Intial Sp3 was bugged and it has been corrected, from the download link it should be SP3a. --Satya http://www.sqlserver-qa.net ... following microsoft page it
      Message 2 of 2 , Oct 1, 2007
        Intial Sp3 was bugged and it has been corrected, from the download
        link it should be SP3a.

        --Satya
        http://www.sqlserver-qa.net
        --- In sqlcon@yahoogroups.com, bhavesh prajapati
        <bhavesh2984groups@...> wrote:
        >
        > Do I have SP3 or SP3a?
        >
        > If you issue a command select @@version and If you visit
        following microsoft page it will say for both SP3 and SP3a the
        version is same as 2000.80.760.0.
        >
        > http://support.microsoft.com/kb/321185
        >
        > Now to determine whether you have SP3 or SP3a installed, you have
        to go to the BINN folder of your SQL Server installation and find the
        DLL file called "Ssnetlib.dll". Right Click --> Properties --> Version
        >
        > If version is
        > 2000.80.760.0, you have SP3
        > 2000.80.766.0, you have SP3a
        >
        >
        >
        > ---------------------------------
        > Now you can chat without downloading messenger. Click here to know
        how.
        >
        > [Non-text portions of this message have been removed]
        >
      Your message has been successfully submitted and would be delivered to recipients shortly.