How to find sql server version

870 Asked by YamamotoSaito in SQL Server , Asked on Jan 6, 2020

It is very important to keep the SQL Server installation up-to-date as sometimes it is required to consider the SQL server edition while obtaining new features by the database. A Database administrator is responsible to know the version and edition details of the SQL Server database.

One of the ways to find the sql server version is :

Launch the command prompt on the SQL Server

In this step, type the command that you desire to give like; SQLCMD -S servernameinstancename

Now type select@@version and then click enter

And then type go and click enter

How to find sql server version

Your Answer