info@techdevops.com
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Replication, Cloud & Migrations



T-SQL Display Operating System Version Information
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2017-07-19









T-SQL:


sys.dm_os_host_info
- Applies to SQL Server running on Windows or on a non-Windows host (i.e. Linux).
- Starting with SQL Server 2017.

sys.dm_os_windows_info
- Only applies to SQL Server running on Windows.
- Starting with SQL Server 2008.