How to identify your SQL Server version and edition

Post date: May 29, 2012 11:05:48 AM

How to determine which version of SQL Server 2008 is running

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

How to determine which version of SQL Server 2005 is running

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

How to determine which version of SQL Server 2000 is running

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

How to determine which version of SQL Server 7.0 is running

SELECT @@VERSION

How to determine which version of SQL Server 6.5 is running

SELECT @@VERSION