Sql-Server

如何找出我擁有的適用於 Linux 的 SQL Server 版本?

  • September 10, 2021

如果由於崩潰而無法連接到它,如何找出正在執行的 SQL 版本?有沒有類似的東西--version

$ ./sqlservr --version
Dump collecting thread [8633] hit exception [6]. Exiting.

使用 dpkg

dpkg -l | grep -i mssql-server
ii  mssql-server                              14.0.3008.27-1                              amd64        Microsoft SQL Server Relational Database Engine

使用PAL_PROGRAM_INFO=1

PAL_PROGRAM_INFO您可以為大量資訊設置未記錄的環境變數,

PAL_PROGRAM_INFO=1 ./sqlservr 
sqlservr
 Version 14.0.3008.27
 Build ID 5fb3474a5f63ad2f4b7eddadad44a086839721f18a66c5fb5d7cfcce25c0f539
 Build Type release
 Git Version 693be7c
 Built at Sat Nov 18 04:54:59 GMT 2017

PAL
 Build ID a984d7631c4f1eb55ae1c77cfb51a09b905528d4e05e728a6343af04e744d96f
 Build Type release
 Git Version 2fe1654
 Built at Sat Nov 18 04:54:06 GMT 2017

Packages
 system.sfp                    6.2.9200.2,2fe1654c9,
 system.common.sfp             10.0.15063.540
 system.certificates.sfp       6.2.9200.2,2fe1654c9,
 system.netfx.sfp              4.6.1590.0
 secforwarderxplat.sfp         14.0.3008.27
 sqlservr.sfp                  14.0.3008.27

引用自:https://dba.stackexchange.com/questions/194581