PowerShell check SQL Server version

PowerShell check SQL Server version.

笔记: Better do this from the Windows Server running 微软SQL服务器

1. 跑步 Windows PowerShell with elevated permissions (作为管理员). As an example, you can do this by Right Mouse Button clicking on the Start button, and selecting WindowsPowerShell (Admin);

2. Run the next command:

sqlcmd -s <SERVERNAME>\<INSTANCENAME>

笔记: If you use only 1 instance on the server you can use the next command

sqlcmd -s <SERVERNAME>

As example:

sqlcmd -s 21-cm01

3. At the 1> prompt, 类型:

select @@version

4. At the 2> prompt, 类型:

go

As a result, you must get something like this. (With your server name and SQL Server version)

就我而言, this is SQL服务器 2017 (RTM-CU13) 14.0.3048.4 (x64)