Does i have any service pack??

• Felipe Venancio

  Mr or Mrs. 500

  Points: 539

  More actions

  March 10, 2005 at 1:05 pm

  #87001

  Does someone knows what service pack, i have on my Sql?

  I have Sql Server 2000.

  Microsoft SQL Server  2000 - 8.00.837 (Intel X86)

   Jun 23 2003 14:50:30

   Copyright (c) 1988-2003 Microsoft Corporation

   Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

   

   

  Thanks and Regards,

  Felipe

• Jim P.

  SSCrazy Eights

  Points: 8725

  More actions

  March 10, 2005 at 2:18 pm

  #546482

  Per http://www.aspfaq.com/show.asp?id=2160 at How do I know which version of SQL Server I'm running? that is 8.00.837 = SP3 / SP3a + KB #823514 (Updated 2005-02-22)

  Have a good day.

  
  
  ----------------
  Jim P.

  A little bit of this and a little byte of that can cause bloatware.

• Mandeep Singh Sangha

  SSC Eights!

  Points: 813

  More actions

  March 10, 2005 at 5:43 pm

  #546514

  Run this query to find which service pack you have:-

  SELECT SERVERPROPERTY('ProductLevel')

  This function returns returns:-

  'RTM' = shipping version

  'SPn' = Service Pack version ('n' being the version no.)

  'Bn' = beta version

• Felipe Venancio

  Mr or Mrs. 500

  Points: 539

  More actions

  March 11, 2005 at 5:51 am

  #546586

  Your are right!!

  Thanks very much!

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  March 11, 2005 at 2:10 pm

  #546738

  here's the Microsoft link:

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

   

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."