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.