SQL Versions

• VegaMachine

  SSCrazy

  Points: 2080

  More actions

  March 4, 2002 at 9:59 am

  #78529

  I would like to be able to tell what service packs a SQL server is sitting on. If I do a Select @@Version I get the version number, but where can I correlate this information with a service pack/Hot fix? The MS HF Tool is very unreleiable to use, it didn't even see a SQL Server running on one machine.

  
  
  - Vega

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  March 4, 2002 at 10:08 am

  #424853

  The readme files for the latest service packs contain this information.

  SQL Server 2000:

  http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Fservicepacks%2Fsql%2F2000%2Fsp2readme%2Easp

  SQL Server 7:

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274798

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 4, 2002 at 10:19 am

  #424855

  For SQL 7

  7.00.623 if SQL Server 7.0 with no service pack applied

  7.00.699 if SQL Server 7.0 Service Pack 1

  7.00.842 if SQL Server 7.0 Service Pack 2

  7.00.961 if SQL Server 7.0 Service Pack 3

  SQL 2000

  8.00.194 SQL Server 2000 RTM

  8.00.384 Database Components SP1

  8.00.532 Database Components SP2

  Of course this list wll have adds as it goes. And I have seen a Stored Procedure to make this easier as far as current SP's but I forget the title to point you in the right direction.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)