SQL DBA Cheatcode : SQL Server properties


follow site 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.

go here 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('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('SqlCharSetName') AS [SqlCharSetName] , SERVERPROPERTY('SqlSortOrder') AS [SqlSortOrder] , SERVERPROPERTY('SqlSortOrderName') AS [SqlSortOrderName]; GO

quiero conocer hombres mayores

Amit Kumar

click here Amit Kumar is a Lead DBA and working with SQL Server Technologies since 2007. Where he focuses on core SQL Server Administration and Development.

source url



  1. Series : SQL DBA Cheatcode - DBA THINGS July 13, 2015 at 7:31 pm

    ome fare i soldi cn la borsa […] SQL DBA Cheatcode : SQL Server properties […]

%d bloggers like this: