SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Output
| 9.00.2047.00 | SP1 | Standard Edition (64-bit) |
To identify which SQL Server version, service pack and edition you are using
To determine which version of Microsoft SQL Server 2005/2008 is running, connect to SQL Server 2005/2008 by using SQL Server Management Studio, and then run the following Transact-SQL statement.