How to know SQL Server version , edition and build version

In this blog I will explain about knowing the SQL Server details like version and edition. So we know the limitation of the server we work with. We could use the command in this blog for SQL SERVER 2005/2008/2012

SQL Server information is critical when you are working on an installation or setup. During the Share Point it is always better to know you environment especially SQL Server so you will not ran into any issues later. Let see how we could extract basic information from SQL Server.

SQL Server Version

 First we need to know the version of SQL Server before any kind of installation. Following command will help us in getting the information.

 

SQL Server Edition

 We need to know what the edition of SQL server in order to avoid any licensing issues; otherwise we may get into licensing issues by installing on a non-enterprise version where we suppose to install the enterprise version.

SQL Server Build Version

We need to know the build version so that it ensures that we are working on correct version of SQL Server. This is critical because sometime we need install software which requires SQL Server with certain service packs, so this could ensure that right service pack are installed and reflected properly on the SQL Server.