DMV – Windows Operating System version information


You can use the DMV on SQL 2008 R2 and above to query Windows OS information

SELECT * FROM sys.dm_os_windows_info

References:

MSDN: http://msdn.microsoft.com/en-us/library/hh204565.aspx

Related Forum thread: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/9753f897-82e3-4602-b7c9-650c7239e83d

Advertisements

Developer @ SQL Server Team, Microsoft

Posted in DMV, SQL Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: