Monday, August 2, 2010

How to identify your SQL Server version and edition

How to identify your SQL Server version and edition


Run the below command in your SQL Server Query Window:


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


Pl. Note: This command will work in SQL 2008, 2005, 2000. not in SQL 7