Which version is correct?

• Kristy

  SSC Enthusiast

  Points: 167

  More actions

  February 8, 2005 at 10:50 am

  #102378

  I used the following queries to determine the SQL Server version running:

   

  1.)sp_server_info

  2.)SELECT @@VERSION

  3.)select SERVERPROPERTY('ProductVersion')

   

  I received the following back:

  1.)Microsoft SQL Server  2000 - 8.00.534 (Intel X86)   Nov 19 2001 13:23:50   Copyright (c) 1988-2000 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

  2.)Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

  3.)8.00.760

  Which is right and why are they different???

  Thanks,

  Kristy

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  February 8, 2005 at 12:07 pm

  #541218

  Don't depend of sp_server_info to be correct.  It select data from the master.dbo.spt_server_info table which is not necessarily kept up-to-date by hot fixes and service packs.  See this article by Steve Jones:

  http://www.sqlservercentral.com/columnists/sjones/gettingyourserverinformation.asp

  Greg

  Greg

• Kristy

  SSC Enthusiast

  Points: 167

  More actions

  February 8, 2005 at 12:31 pm

  #541226

  Ok, the reason I was wondering was because I seem to be getting some errors and microsoft website usualy says that they are fixed in SP3. So I didn't know if there was a possibility that the SP didn't completely update everything.

  --Kristy