SQL Server Version

SQL Server | Nauman | November 1, 2009 at 8:17 am

If you need to know the version you are currently running of SQL Server you can easily get it by running the following query.

SELECT ‘ SQL Server ‘ +

CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ productversion ‘ )) + ‘ – ‘ +

CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ productlevel ‘ )) + ‘ – ‘ +

CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ edition ‘ ))