SELECT
SERVERPROPERTY('servername') as ServerName,
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as ComputerName,
SERVERPROPERTY('edition') as Edition,
SERVERPROPERTY('productlevel') as [Prod.Level],
SERVERPROPERTY('productversion') as ProductVersion,
SERVERPROPERTY('IsClustered') as IsClustered,
SERVERPROPERTY('SqlCharSet') as SqlCharSet,
SERVERPROPERTY('SqlCharSetName') as SqlCharSetName,
SERVERPROPERTY('SqlSortOrder') as SqlSortOrder,
SERVERPROPERTY('SqlSortOrderName') as SqlSortOrderName
