Find which SQL Server Edition is in your Production Setup

You are trying to figure out which edition of SQL Server is installed in Production setup. You can use simple command to find the details of SQL Server Edition as well as OS details by using

 

Select @@version

 

The output of this command will give you following information-

—————————————————————————————————————

Microsoft SQL Server 2008 R2 (SP1) Р10.50.2500.0 (X64)   Jun 17 2011 00:54:03
Copyright (c) Microsoft Corporation  Developer Edition (64-bit)
on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

—————————————————————————————————————–

It confirms that x64 Windows Server 2008 R2 Service Pack 1 is installed. SQL Server is Developer Edition of 64 bit.