How to check SQL server version name using command prompt?

1. Open a Command Prompt Window

• Search for "cmd" in the Windows search bar and open the Command Prompt.

2. Connect to SQL Server using sqlcmd

• Use the following command to connect to your SQL Server instance:

sqlcmd -S <servername>\\<instancename>

• Replace <servername> with the name of your server (e.g., "your_server_name") and <instancename> with the name of your SQL Server instance (e.g., "MSSQLSERVER"). If you're connecting to the default instance, you can omit the <instancename> part.

3. Execute the Query

• At the 1> prompt, enter the following query:

SQL

SELECT @@version;

• Press Enter.

4. View the Version Information

• At the 2> prompt, type go and press Enter. This will execute the query.
• The output will display detailed information about your SQL Server version, including the edition, version number, and build information.

Example

C:\\>sqlcmd -S your_server_name\\MSSQLSERVER
1> SELECT @@version;
2> go
Microsoft SQL Server 2022 (RTM-CU17) (x64)
    Copyright (C) 2019 Microsoft Corporation
    Standard Edition (64-bit) on Windows
    (Build 15.0.4244.1)

In this example:

• Microsoft SQL Server 2022 (RTM-CU17): This is the SQL Server version.
• Standard Edition (64-bit): This is the SQL Server edition.
• (Build 15.0.4244.1): This is the build number of the SQL Server installation.

Note:

• If you're connecting to a remote SQL Server instance, you may need to provide authentication credentials (username and password) using the U and P options with the sqlcmd command.
• For more information about the sqlcmd utility and its options, refer to the Microsoft SQL Server documentation.