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 ‘ ))