SQL Server – How to Determine Which Version

To determine which version of Microsoft SQL Server is running, connect to SQL Server by using SQL Server Management Studio, and then run the following Transact-SQL statement. For SQL 2008, 2005, 2000: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) The following results are returned: The product version (for example, 10.0.1600.22) The product level (for example, RTM) The edition (for example, Enterprise) For example, the results resemble the following. 10.0.1600.22 RTM Enterprise Edition The following table lists the Sqlservr.exe version number. Release Sqlservr.exe SQL Server 2008 RTM 2007.100.1600.0 SQL Server 2008 Service Pack 1 2007.100.2531.0 SQL Server 2005 RTM 2005.90.1399 SQL Server … Continue reading SQL Server – How to Determine Which Version