Microsoft SQL Server – Find SQL Server Version and Edition

How to find or check installed SQL Server Version and Edition in cmd?

Solution:

         On Computer running SQL Server: 

Open Command Prompt on  the computer running SQL Server (Start-Run-Cmd)

Once command prompt is open, enter the below command:

Start-Run-Cmd

      (Type) SQLCMD -S servername\instancename  (Press Enter)

 1> (Type) select @@version (Press Enter)

 2> (Type) go (Press Enter)

Contact: support@smartmilestones.com