Users: 30k; Pages Per Session: 2.5p; Avg. Session Duration: 1:35mi
TechDevOps.com
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}



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.