This extended stored procedure has been documented and blogged elsewhere, however, I just discovered it today, and I thought it was cool enough, I'm reblogging it anyway.
xp_msver was a new extended stored procedure included with the release of SQL Server 2008.
Online documentation for SQL 2008 R2 version is the version most of my servers have so documentation link is here: xp_msver (Transact-SQL)
When xp_msver is issued at editor window, we get pretty comprehensive system information:
|ProductName||NULL||Microsoft SQL Server|
|Language||1033||English (United States)|
|FileDescription||NULL||SQL Server Windows NT - 64 Bit|
|LegalCopyright||NULL||Microsoft Corp. All rights reserved.|
|LegalTrademarks||NULL||Microsoft SQL Server is a registered trademark of Microsoft Corporation.|
(left off Index column to save space)
Very cool way to do a quick-and-dirty system inventory on each SQL instance.