MS SQL server verzija

Kako naći verziju MS SQL servera, bilo da je server up ili down?

Odličan link!

Remotely :

a) Korišćenjem MS SQM SMS-a i upita “select @@version

b) Kroz PowerShell pokrenut kao MS SQL administrator, sa upitom : “

PS D:\Skriptici> invoke-sqlcmd -query “select @@version” -serverinstance “mojserver.mojdomen”

Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) – 13.0.1742.0 (X64) …

Direktno logovani na MS SQL server :

a) Pronaći fajl sqlservr.exe, i videti njegove “Properties/Details/Product version”. To je prilično dugačak broj, sa tačkama između sekvenci. Ovako se tumači :

  • 8.0 for SQL Server 2000
  • 9.0 for SQL Server 2005
  • 10.0 for SQL Server 2008
  • 10.5 for SQL Server 2008 R2
  • 11.0 for SQL Server 2012
  • 12.0 for SQL Server 2014
  • 13.0 for SQL Server 2016
  • 14.0 for SQL Server 2017

 

 

This entry was posted in Windows and tagged , . Bookmark the permalink.

Leave a Reply

Your email address will not be published.

*