SQL DBA Cheatcode : SQL Server properties


http://creativebu.com/lyjatatog see url source url https://www.shophomoreonline.com/gambling/professional-gambling-websites Online Video Casino Games Are online casinos allowed in Germany source link In this article I am trying to outline about some important server properties which can help you out at the time of auditing and trace history of SQL Server. It has been checked in various SQL versions like SQL 2005, 2008, 2008 R2 and 2012.

SELECT SERVERPROPERTY('BuildClrVersion') AS [BuildClrVersion]
 , SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ComputerNamePhysicalNetBIOS
 , SERVERPROPERTY('ServerName') AS [ServerName]
 , SERVERPROPERTY('InstanceName') AS [InstanceName]
 , SERVERPROPERTY('Collation') AS [Collation]
 , SERVERPROPERTY('ComparisonStyle') AS [ComparisonStyle]
 , SERVERPROPERTY('Edition') AS [Edition]
 , SERVERPROPERTY('EngineEdition') AS [EngineEdition]
 , SERVERPROPERTY('IsClustered') AS [IsClustered]
 , SERVERPROPERTY('IsFullTextInstalled') AS [IsFullTextInstalled]
 , SERVERPROPERTY('IsIntegratedSecurityOnly') AS [IsIntegratedSecurityOnly]
 , SERVERPROPERTY('IsSingleUser') AS [IsSingleUser]
 , 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('SqlCharSetName') AS [SqlCharSetName]
 , SERVERPROPERTY('SqlSortOrder') AS [SqlSortOrder]
 , SERVERPROPERTY('SqlSortOrderName') AS [SqlSortOrderName];
  1. […] SQL DBA Cheatcode : SQL Server properties […]