info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



T-SQL Display Operating System Version Information
by BF (Principal Consultant; Architecture; Engineering)
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.