Jack Dawson February 2016

Can't get information about SQL Server

I am creating some ERS (Error Reporting Service) in my SQL Server 2008 R2. Introducing part of the report should contain some basic information about version of SQL Server, Windows info etc...

I have two queries which work fine on my virtual machine, but at my host machine I have problem with sys.dm_os_windows_info.

This basic query throws the error:

SELECT * 
FROM sys.dm_os_windows_info;

Error:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.dm_os_windows_info'.

Answers


Joe Stefanelli February 2016

You need at least SP1 on SQL Server 2008 R2 (10.50.2500 or later) to use this.

sys.dm_os_windows_info Documentation.

SQL Server Versions

Post Status

Asked in February 2016
Viewed 2,940 times
Voted 5
Answered 1 times

Search




Leave an answer