How to know the version of the sqlserver and operating system used for sqlserver by command.

• amarbreddy21

  SSC Veteran

  Points: 275

  More actions

  September 11, 2009 at 4:14 pm

  #135009

  Hi All

  How to know the version of the sqlserver and operating system used for sqlserver by command.

• Marcin Gol

  Hall of Fame

  Points: 3314

  More actions

  September 11, 2009 at 5:20 pm

  #1052618

  if version means build : select @@version

• Paul O'Kasick

  SSC Veteran

  Points: 208

  More actions

  September 11, 2009 at 7:16 pm

  #1052620

  Here's a script I use to get the this information. It provides pretty much the same information.

  /*

  This script displays SQL Server version information, but it does not

  identify the service pack. I found a Microsoft knowledge base article

  that describes how to tell.

  The value of the ProductVersion indicates the service pack. This information

  was taken from http://support.microsoft.com/kb/321185

  Release Sqlservr.exe

  RTM 2005.90.1399

  SP1 2005.90.2047

  SP2 2005.90.3042

  */

  SET NOCOUNT ON

  SELECT CAST(@@SERVERNAME AS VARCHAR(25)) AS ServerName,

  CAST(SERVERPROPERTY('productversion') AS VARCHAR(25)) AS Version,

  CAST(SERVERPROPERTY ('productlevel') AS VARCHAR(12)) AS Level,

  CAST(SERVERPROPERTY ('edition') AS VARCHAR(40)) AS Edition

  PRINT @@SERVERNAME

  PRINT ''

  EXEC xp_msver