How to identify which version of SQL Server 2008 is running?

To identify which version of Microsoft SQL Server 2008 is running, connect to SQL Server 2008 by using SQL Server Management Studio, and run the following T-SQL statement.

SELECT SERVERPROPERTY ('edition'), SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel')

Above query will return resultset like

Edition  -- for example - Enterprise
Product Version -- for example - 10.0.1600.22
Product Level -- for example - RTM

Following table shows SQL Server 2008 releases.

Release Version
RTM 10.00.1600
SQL Server 2008 Service Pack 1 10.00.2531
SQL Server 2008 Service Pack 2 10.00.4000


Other SQL Server Releases:
 
How to identify which version of SQL Server 6.5 is running?
 
How to identify which version of SQL Server 7.0 is running?

How to identify which version of SQL Server 2000 is running?

How to identify which version of SQL Server 2005 is running?

Category

Recent Posts

Tag cloud