What version of SQL is installed
To determine what version of SQL is installed:
SELECT SERVERPROPERTY('productversion')
, SERVERPROPERTY ('productlevel')
, SERVERPROPERTY ('edition')
Results for SQL 2008:
| Release | Sqlservr.exe |
| RTM | 2007.100.1600.0 |
| SQL Server 2008 Service Pack 1 | 2007.100.2531.0 |