Gets the Database Engine edition of the instance of SQL Server installed on the server. 1 =Personal or Desktop Engine 2 =Standard ...

Gets the Database Engine edition of the instance of SQL Server installed on the server.
1 =Personal or Desktop Engine
2 =Standard (This is returned for Standard, Workgroup and Business Intelligence.)
3 =Enterprise (This is returned for Enterprise, Enterprise Evaluation, and Developer.)
4 =Express (This is returned for Express, Express with Advanced Services, and Windows Embedded SQL.)

Gets the Boolean property value that specifies whether the server data definition language (DDL) trigger is a system object. ... Gets the Boolean property value that specifies whether the statistic counter was generated from the creation of an index. ... 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 estimated time to recover the transaction log of the secondary database replica, given the current redo queue size ... Gets the greatest decimal precision available for exact numeric data types (not floating point), including decimal and numeric. ... Gets the LSN value for the end of log on the primary database replica before it writes any new log records after recovery ... Gets the NetBIOS name of the local computer on which the instance of SQL Server is currently running. For a clustered instance ...