service pack

• Jyothirmayee Gummuluri

  Valued Member

  Points: 57

  More actions

  January 20, 2006 at 5:38 am

  #90510

  How to know the service pack of the sql server which is running?:

• David.Poole

  SSC Guru

  Points: 75992

  More actions

  January 20, 2006 at 5:44 am

  #616027

  SELECT @@VERSION

  SP3 = 8.00.760

  SP4 = 8.00.2039

  SP4 plus embarrassing fix for memory problem in SP4 = 8.00.2040.

  You should be on at least SP3

  LinkedIn Profile

• HemaSunder Bugatha

  Right there with Babe

  Points: 737

  More actions

  January 20, 2006 at 5:48 am

  #616030

  we tried in sql server 2000 Enterprise Edition

   but it just mentioned the version and when it was built but not the service pack.

  Is there any other way other than that..

  sunder..

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  January 20, 2006 at 7:19 am

  #616062

  Hello Sunder,

  You can also try this query in Query Analyzer

  SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

  also go through this webpage from Microsoft

  http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

  Hope this is helpful to you.

  Thanks and have a nice day!!!

  
  Lucky