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,
SERVERPROPERTY(‘FilestreamShareName’) AS FilestreamShareName,
SERVERPROPERTY(‘FilestreamConfiguredLevel’) AS FilestreamConfiguredLevel,
SERVERPROPERTY(‘FilestreamEffectiveLevel’) AS FilestreamEffectiveLevel

SELECT
DATABASEPROPERTYEX (N’master’,’Collation’) AS Collation,
DATABASEPROPERTYEX (N’master’,’ComparisonStyle’) AS ComparisonStyle,
DATABASEPROPERTYEX (N’master’,’IsAnsiNullDefault’) AS IsAnsiNullDefault,
DATABASEPROPERTYEX (N’master’,’IsAnsiNullsEnabled’) AS IsAnsiNullsEnabled,
DATABASEPROPERTYEX (N’master’,’IsAnsiPaddingEnabled’) AS IsAnsiPaddingEnabled,
DATABASEPROPERTYEX (N’master’,’IsAnsiWarningsEnabled’) AS IsAnsiWarningsEnabled,
DATABASEPROPERTYEX (N’master’,’IsArithmeticAbortEnabled’) AS IsArithmeticAbortEnabled,
DATABASEPROPERTYEX (N’master’,’IsAutoClose’) AS IsAutoClose,
DATABASEPROPERTYEX (N’master’,’IsAutoCreateStatistics’) AS IsAutoCreateStatistics,
DATABASEPROPERTYEX (N’master’,’IsAutoShrink’) AS IsAutoShrink,
DATABASEPROPERTYEX (N’master’,’IsAutoUpdateStatistics’) AS IsAutoUpdateStatistics,
DATABASEPROPERTYEX (N’master’,’IsCloseCursorsOnCommitEnabled’) AS IsCloseCursorsOnCommitEnabled,
DATABASEPROPERTYEX (N’master’,’IsFulltextEnabled’) AS IsFulltextEnabled,
DATABASEPROPERTYEX (N’master’,’IsInStandBy’) AS IsInStandBy,
DATABASEPROPERTYEX (N’master’,’IsLocalCursorsDefault’) AS IsLocalCursorsDefault,
DATABASEPROPERTYEX (N’master’,’IsMergePublished’) AS IsMergePublished,
DATABASEPROPERTYEX (N’master’,’IsNullConcat’) AS IsNullConcat,
DATABASEPROPERTYEX (N’master’,’IsNumericRoundAbortEnabled’) AS IsNumericRoundAbortEnabled,
DATABASEPROPERTYEX (N’master’,’IsParameterizationForced’) AS IsParameterizationForced,
DATABASEPROPERTYEX (N’master’,’IsQuotedIdentifiersEnabled’) AS IsQuotedIdentifiersEnabled,
DATABASEPROPERTYEX (N’master’,’IsPublished’) AS IsPublished,
DATABASEPROPERTYEX (N’master’,’IsRecursiveTriggersEnabled’) AS IsRecursiveTriggersEnabled,
DATABASEPROPERTYEX (N’master’,’IsSubscribed’) AS IsSubscribed,
DATABASEPROPERTYEX (N’master’,’IsSyncWithBackup’) AS IsSyncWithBackup,DATABASEPROPERTYEX (N’master’,’IsTornPageDetectionEnabled’) AS IsTornPageDetectionEnabled,
DATABASEPROPERTYEX (N’master’,’LCID’) AS LCID,
DATABASEPROPERTYEX (N’master’,’Recovery’) AS Recovery,
DATABASEPROPERTYEX (N’master’,’SQLSortOrder’) AS SQLSortOrder,
DATABASEPROPERTYEX (N’master’,’Status’) AS Status,
DATABASEPROPERTYEX (N’master’,’Updateability’) AS Updateability,
DATABASEPROPERTYEX (N’master’,’UserAccess’) AS UserAccess,
DATABASEPROPERTYEX (N’master’,’Version’) AS Version