Service Pack

• Jeetendra

  SSCrazy

  Points: 2076

  More actions

  August 1, 2006 at 4:36 am

  #75026

  Hi gurus,

  I have a question regarding the SP's:-

  1. When i execute the command:

  Select @@version

  Output is :Microsoft SQL Server  2000 - 8.00.929 (Intel X86)   Apr  6 2004 11:46:57   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

  2. When i execute the command:

  Select Serverproperty('ProductLevel')

  Output is : SP3

  So how to conclude the SQL Server is having which SP Installed.

  ---

  Kindest Regards,

  Jeetendra
  

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  August 1, 2006 at 5:57 am

  #652549

  Refer to

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

  Far away is close at hand in the images of elsewhere.
  Anon.

• Neil Coombes

  Valued Member

  Points: 64

  More actions

  August 2, 2006 at 7:59 am

  #652813

  You are on SP3, the bit at the end stating you are on SP4 is referring to your OS.  The relevant part of the output of @@version for your SLQ build is: Microsoft SQL Server  2000 - 8.00.929

  Its pretty confusing to have the windows service pack number there but not state the sql server service pack too but I guess thats a minor issue in the grand scheme of things.

• Lance Sanders

  SSC Eights!

  Points: 903

  More actions

  August 2, 2006 at 7:33 pm

  #652973

  SQLSecurity.com's version database is useful. Let's you know which hotfixes are installed as well.

  http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx