Gets the NetBIOS name of the local computer on which the instance of SQL Server is currently running. For a clustered instance ...

Gets the NetBIOS name of the local computer on which the instance of SQL Server is currently running. For a clustered instance of SQL Server on a failover cluster, this value changes as the instance of SQL Server fails over to other nodes in the failover cluster. On a stand-alone instance of SQL Server, this value remains constant and returns the same value as the MachineName property.

Gets the Boolean value that indicates whether the table or index has compressed partitions. This property also returns True ... Gets the Boolean value that specifies whether the full-text component is installed with the current instance of SQL Server. ... Gets the Database Engine edition of the instance of SQL Server installed on the server. 1 =Personal or Desktop Engine 2 =Standard ... Gets the greatest decimal precision available for exact numeric data types (not floating point), including decimal and numeric. ... Gets the NetBIOS name of the local computer on which the instance of SQL Server is currently running. For a clustered instance ... Gets the retention period specifying how long the change tracking data is kept in the database if autocleanup is being used. ... Gets the type of login that is associated with the database user, such as whether it is a Microsoft Windows group or a Microsoft ... Gets the version of the Microsoft .NET Framework common language runtime (CLR) that was used while building the instance ... Granularity requires AttributeHierarchyEnabled to be true for CubeAttribute (if the CubeAttribute is explicitly included/defined ...