SQL Server 2005 or 2008

• sagarkavitake11

  Valued Member

  Points: 57

  More actions

  April 10, 2010 at 7:43 am

  #221133

  when I am connected to a sql-server,

  how can i know that i am connected to sql server 2005 or sql server 2008 ?

  Is there any property like '@@property' which gives reslut as 2005 or 2008?

  Sagar

• Paul White

  SSC Guru

  Points: 150468

  More actions

  April 10, 2010 at 10:43 am

  #1149593

  There are many methods available:

  How to identify your SQL Server version and edition

  SERVERPROPERTY

  @@VERSION

  xp_msver

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi