PowerShell check SQL Server version.
OPOMBA: Better do this from the Windows Server running Microsoft SQL Server
1. Teči Windows PowerShell with elevated permissions (kot skrbnik). Kot primer, you can do this by Right Mouse Button clicking on the Start button, and selecting WindowsPowerShell (skrbnik);
2. Zaženite naslednji ukaz:
sqlcmd -s <SERVERNAME>\<INSTANCENAME>
OPOMBA: If you use only 1 instance on the server you can use the next command
sqlcmd -s <SERVERNAME>
Kot primer:
sqlcmd -s 21-cm01
3. At the 1> prompt, vrsto:
select @@version
4. At the 2> prompt, vrsto:
go
As a result, you must get something like this. (With your server name and SQL Server version)
V mojem primeru, to je SQL Server 2017 (RTM-CU13) 14.0.3048.4 (x64)