How do I find my local SQL Server version?

How can I tell what version of SQL Server I have without management studio?

Alternative, no-fuss methods:1Check the registry: Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\{VersionNumber}\Tools\Setup. Name: Edition. ... 2Check the installation log: C:\Program Files\Microsoft SQL Server\{SQL Server Version: 110, 120, etc}\Setup Bootstrap\Log\{date_time}\Detail.txt.

What version of SQL Server do I have command line?

To determine what edition of SQL you are running, do the following: Open a command prompt windows on the machine SQL is installed to (Start > Run, type cmd, hit enter) Type SQLCMD -S servername\instancename (where servername = the name of your server, and instancename is the name of the SQL instance).

How can check SQL version from command line?

How to check SQL server version name using command prompt?1Step 1 -Open a command prompt window on the machine in which SQL is installed. ... 2Step 2 -SQLCMD -S servername\instancename (where servernameb= the name of your server, and instancename is the name of the SQL instance). ... 3Step 3 -select @@version.

How do I know if local SQL Server is installed?

Click Start, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager. If you do not have these entries on the Start menu, SQL Server is not correctly installed. Run Setup to install the SQL Server Database Engine.