Sql-server – How to tell which version of SQL Server 2008 is running on a server

licensingsql serversql-server-2008

I'm trying to square up licensing, and I'm looking at a few SQL 2008 boxes that are in a cluster and I can not see where it says Enterprise Edition anywhere, even though I know that's what it's running.

I need to figure this out, because I have a few Reporting Servers that are on Virtual Machines that may or may not be running Enterprise Edition.

I can't do this through a query since the DB Services are not installed on the Reporting Servers. However, I still have to license those boxes

Best Answer

From KB321185:

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