-
a GST Software that do not require you to have much GST Knowledge!
Support Center > Knowledge base> Article: [Optimum] How to identify your SQL Server Version and Edition

[Optimum] How to identify your SQL Server Version and Edition

Article ID: 93814 Email Print
Question
How to identify your SQL Server Version and Edition?

Answer

Using the Windows Command Prompt

To determine what edition of SQL you are running, do the following:

  1. Open a command prompt windows on the machine SQL is installed to (Start > Run, type cmd, hit enter)

  2. Type SQLCMD -S servername\instancename (where servername = the name of your server, and instancename is the name of the SQL instance).The prompt will change to 1>
  3. Type select @@version and hit <ENTER>.
  4. At the 2> prompt type go and hit <ENTER>.

This will return the SQL version that is running on your server. If you have multiple instances repeat the process for each instance.

The servername mentioned above will be the name of the machine SQL is installed to. If you are unsure of your instance name do the following:

  1. Open a command prompt window as described above.
  2. Type services.msc.
  3. Browse down to entries beginning with SQL.
  4. There will be an entry for each instance called SQL Server (instancename).
  5. Whatever appears in the parentheses is your instance name.

 

Sample output:

 

 


related articles

Article Details
Views: 219 Created on: Nov 28, 2017
Date updated: Nov 28, 2017

Poor Outstanding