CREATE VIEW dbo.GetServerInfo
AS
/*
Author: Scott Whigham ( http://www.LearnSqlServer.com )
Description: Returns a list of every property exposed by SERVERPROPERTY()
Create Date: Aug 17, 2006

Last checked against July, 2006 Books Online for every option of SERVERPROPERTY
    
For more SQL Server scripts and ideas, visit http://forums.learnsqlserver.com/CodeSamples.aspx
*/
SELECT SERVERPROPERTY('BuildClrVersion') AS [BuildClrVersion]
, SERVERPROPERTY('Collation') AS [Collation]
, SERVERPROPERTY('CollationID') AS [CollationID]
, SERVERPROPERTY('ComparisonStyle') AS [ComparisonStyle]
, SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ComputerNamePhysicalNetBIOS
, SERVERPROPERTY('Edition') AS [Edition]
, SERVERPROPERTY('EditionID') AS [EditionID]
, SERVERPROPERTY('EngineEdition') AS [EngineEdition]
, SERVERPROPERTY('InstanceName') AS [InstanceName]
, SERVERPROPERTY('IsClustered') AS [IsClustered]
, SERVERPROPERTY('IsFullTextInstalled') AS [IsFullTextInstalled]
, SERVERPROPERTY('IsIntegratedSecurityOnly') AS [IsIntegratedSecurityOnly]
, SERVERPROPERTY('IsSingleUser') AS [IsSingleUser]
, SERVERPROPERTY('LCID') AS [LCID]
, SERVERPROPERTY('LicenseType') AS [LicenseType]
, SERVERPROPERTY('MachineName') AS [MachineName]
, SERVERPROPERTY('NumLicenses') AS [NumLicenses]
, SERVERPROPERTY('ProcessID') AS [ProcessID]
, SERVERPROPERTY('ProductVersion') AS [ProductVersion]
, SERVERPROPERTY('ProductLevel') AS [ProductLevel]
, SERVERPROPERTY('ResourceLastUpdateDateTime') AS [ResourceLastUpdateDateTime]
, SERVERPROPERTY('ResourceVersion') AS [ResourceVersion]
, SERVERPROPERTY('ServerName') AS [ServerName]
, SERVERPROPERTY('SqlCharSet') AS [SqlCharSet]
, SERVERPROPERTY('SqlCharSetName') AS [SqlCharSetName]
, SERVERPROPERTY('SqlSortOrder') AS [SqlSortOrder]
, SERVERPROPERTY('SqlSortOrderName') AS [SqlSortOrderName]
GO
SELECT * FROM dbo.GetServerInfo