Join Us!

Spaces are allowed; punctuation is not allowed except for periods, hyphens, and underscores.
A valid e-mail address. All e-mails from the system will be sent to this address. The e-mail address is not made public and will only be used if you wish to receive a new password or wish to receive certain news or notifications by e-mail.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.

Login

Enter your Project Envision username.
Enter the password that accompanies your username.
Request new password

How to check the version of Microsoft Sql Server

by Krystian Zieja on June 18, 2009 - 00:04

Often we need quickly check the version of the Microsoft Sql Server. The quickest way to do it is to use @@VERSION. However there is one more method, which is often overlooked by Database Administrators, the extended stored procedure xp_msver.

@@VERSION returns version, processor architecture, build date, and operating system.

select @@VERSION
Microsoft SQL Server 2005 - 9.00.3077.00 (Intel X86)   Dec 17 2008 15:19:45   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Dodatek Service Pack 2)

Stored Procedure xp_msver returns more detailed output than @@VERSION, as it is shown on example below

exec xp_msver 



 

  1
  ProductName
  NULL
  Microsoft SQL Server
 

 

  2
  ProductVersion
  589824
  9.00.3077.00
 

 

  3
  Language
  1033
  Angielski (Stany Zjednoczone)
 

 

  4
  Platform
  NULL
  NT INTEL X86
 

 

  5
  Comments
  NULL
  NT INTEL X86
 

 

  6
  CompanyName
  NULL
  Microsoft Corporation
 

 

  7
  FileDescription
  NULL
  SQL Server Windows NT
 

 

  8
  FileVersion
  NULL
  2005.090.3077.00
 

 

  9
  InternalName
  NULL
  SQLSERVR
 

 

  10
  LegalCopyright
  NULL
  © Microsoft Corp. All rights reserved.
 

 

  11
  LegalTrademarks
  NULL
  Microsoft® is a registered trademark of Microsoft
  Corporation. Windows(TM) is a trademark of Microsoft Corporation
 

 

  12
  OriginalFilename
  NULL
  SQLSERVR.EXE
 

 

  13
  PrivateBuild
  NULL
  NULL
 

 

  14
  SpecialBuild
  201654272
  NULL
 

 

  15
  WindowsVersion
  170393861
  5.1 (2600)
 

 

  16
  ProcessorCount
  2
  2
 

 

  17
  ProcessorActiveMask
  3
  3
 

 

  18
  ProcessorType
  586
  PROCESSOR_INTEL_PENTIUM
 

 

  19
  PhysicalMemory
  3070
  3070 (3219501056)
 

 

  20
  Product ID
  NULL
  NULL
Categories: