querying version of SQL server

• sahana

  SSCrazy

  Points: 2530

  More actions

  August 25, 2005 at 1:27 pm

  #102741

  Which command using Query Analyzer will give you the version of SQL server and operating system

   

  Thanks.

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  August 25, 2005 at 1:32 pm

  #585155

  exec xp_msver

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  August 25, 2005 at 1:35 pm

  #585158

  you can also do a "SELECT @@VERSION" and set the QA tools - options - results - to display the results as "text"!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• Karl Klingler

  SSCertifiable

  Points: 5869

  More actions

  August 26, 2005 at 9:44 am

  #585486

  SELECT RTRIM(CONVERT(varchar,SERVERPROPERTY('productversion')))as Productversion,

  RTRIM(CONVERT(varchar,SERVERPROPERTY ('productlevel')))as Productlevel,

  RTRIM(CONVERT(varchar,SERVERPROPERTY ('edition'))) as Edition

  EXEC master.dbo.xp_msver

  Best regards
  karl