PowerShell check SQL Server version

PowerShell check SQL Server version.

메모: Better do this from the Windows Server running Microsoft SQL Server

1. 달리다 윈도우 파워셸 with elevated permissions (as administrator). As an example, you can do this by Right Mouse Button clicking on the Start button, and selecting WindowsPowerShell (Admin);

2. 다음 명령을 실행하십시오:

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, type:

select @@version

4. At the 2> prompt, type:

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)