Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

How can I tell what version of SQL Server I have?

Contents
  1. How can I tell what version of SQL Server I have without management studio?
  2. How can check SQL version from command line?
How to tell what version of Microsoft SQL Server you are running? One simple way to do this is to run SELECT @@version. Another option is to right click on the SQL Server instance name in SSMS and select Properties. You can also use the SERVERPROPERTY function to get details about the version of SQL Server.


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.

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.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours