SQL Server Version
November 1, 2009 by Nauman · Leave a Comment
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 ‘ ))
