SQL Database| Base Class | Microsoft.SQLServer.Database |
| Abstract | False |
| Hosted | True |
| Singleton | False |
| Extension | False |
| Accessibility | Public |
| ElementId | 145a9582-2bac-91cd-d5de-2ec980787695 |
| Property Name | Type | Display Name (ENU) | Description (ENU) | Key | Max Length | Min Length | Case Sensitive |
|---|---|---|---|---|---|---|---|
| System.Entity: | |||||||
 DisplayName |
string | Display Name | Display name of monitoring object. | false | 256 | 0 | False |
| Microsoft.SQLServer.Database: | |||||||
 DatabaseName |
string | Database Name | true | 256 | 0 | False | |
| RecoveryModel |
string | Recovery Model | false | 256 | 0 | False | |
| DatabaseAutogrow |
string | Database Autogrow Set | false | 256 | 0 | False | |
| DatabaseSize |
string | Database Size (MB) (String) (Deprecated) | false | 256 | 0 | False | |
| DatabaseSizeNumeric |
int | Database Size (MB) (Numeric) (Deprecated) | false | 256 | 0 | ||
| LogAutogrow |
string | Log Autogrow Set | false | 256 | 0 | False | |
| Updateability |
string | Updateability | false | 256 | 0 | False | |
| UserAccess |
string | User Access | false | 256 | 0 | False | |
| Collation |
string | Collation | false | 256 | 0 | False | |
| LogSize |
string | Log Size (MB) (String) (Deprecated) | false | 256 | 0 | False | |
| LogSizeNumeric |
int | Log Size (MB) (Numeric) (Deprecated) | false | 256 | 0 | ||
| Owner |
string | Owner | false | 256 | 0 | False | |
| Microsoft.KnowledgeServices.SQLServer.Database: | |||||||
| DatabaseId |
int | DatabaseId | ID of the database | false | 256 | 0 | |
| PageVerify |
string | PageVerify | The page_verify option | false | 256 | 0 | False |
| Status |
string | Status | The status of the database | false | 256 | 0 | False |
| IsMirroringEnabled |
bool | IsMirroringEnabled | Is Database Mirroring Enabled | false | 256 | 0 | |
| MirroringRole |
string | MirroringRole | This is either Principal or Mirror indicating the mirroring role description. If mirroring is not enabled, it is null or blank. | false | 256 | 0 | False |
| CreateDate |
datetime | CreateDate | Database Created Date | false | 256 | 0 | |
| CompatibilityLevel |
string | CompatibilityLevel | CompatibilityLevel | false | 256 | 0 | False |
| ReadOnly |
bool | ReadOnly | IsReadOnly | false | 256 | 0 | |
| AutoClose |
bool | AutoClose | IsAutoCloseOn | false | 256 | 0 | |
| AutoShrink |
bool | AutoShrink | IsAutoShrinkOn | false | 256 | 0 | |
| StandBy |
bool | StandBy | is in standby | false | 256 | 0 | |
| CleanlyShutdown |
bool | CleanlyShutdown | IsCleanlyshutdown | false | 256 | 0 | |
| SnapshotIsolationState |
string | SnapshotIsolationState | snapshotIsolationState | false | 256 | 0 | False |
| IsReadCommittedSnapshotOn |
bool | ReadCommittedSnapshot | Is Read committed snapshot on | false | 256 | 0 | |
| AutoCreateStatisticsEnabled |
bool | AutoCreateStatisticsEnabled | is Auto create statistics enabled | false | 256 | 0 | |
| AutoUpdateStatisticsEnabled |
bool | AutoUpdateStatisticsEnabled | is auto update statistics enabled | false | 256 | 0 | |
| AutoUpdateStatisticsAsync |
bool | AutoUpdateStatisticsAsync | is auto update statistics async on | false | 256 | 0 | |
| AnsiNullDefault |
bool | AnsiNullDefault | is ansi null default on | false | 256 | 0 | |
| AnsiNullsEnabled |
bool | AnsiNullsEnabled | is Ansi null enabled | false | 256 | 0 | |
| AnsiPaddingEnabled |
bool | AnsiPaddingEnabled | is Ansi padding enabled | false | 256 | 0 | |
| AnsiWarningsEnabled |
bool | AnsiWarningsEnabled | is ansi warning enabled | false | 256 | 0 | |
| ArithmeticAbortEnabled |
bool | ArithmeticAbortEnabled | is arithmetic abort enabled | false | 256 | 0 | |
| ConcatenateNullYieldsNull |
bool | ConcatenateNullYieldsNull | is concatenate null yields null on | false | 256 | 0 | |
| NumericRoundAbortEnabled |
bool | NumericRoundAbortEnabled | is numeric round abort enabled | false | 256 | 0 | |
| QuotedIdentifiersEnabled |
bool | QuotedIdentifiersEnabled | is quoted identifier enabled | false | 256 | 0 | |
| RecursiveTriggersEnabled |
bool | RecursiveTriggersEnabled | Is recursive triggers enabled | false | 256 | 0 | |
| IsFullTextEnabled |
bool | IsFullTextEnabled | Is Full Text Enabled | false | 256 | 0 | |
| Trustworthy |
bool | Trustworthy | Trustworthy | false | 256 | 0 | |
| DatabaseOwnershipChaining |
bool | DatabaseOwnershipChaining | DatabaseOwnershipChaining | false | 256 | 0 | |
| IsParameterizationForced |
bool | IsParameterizationForced | IsParameterizationForced | false | 256 | 0 | |
| IsMasterKeyEncryptedByServer |
bool | IsMasterKeyEncryptedByServer | IsMasterKeyEncryptedByServer | false | 256 | 0 | |
| IsPublished |
bool | IsPublished | IsPublished | false | 256 | 0 | |
| IsSubscribed |
bool | IsSubscribed | IsSubscribed | false | 256 | 0 | |
| IsMergePublished |
bool | IsMergePublished | IsMergePublished | false | 256 | 0 | |
| IsDistributor |
bool | IsDistributor | IsDistributor | false | 256 | 0 | |
| IsSyncWithBackup |
bool | IsSyncWithBackup | IsSyncWithBackup | false | 256 | 0 | |
| BrokerEnabled |
bool | BrokerEnabled | BrokerEnabled | false | 256 | 0 | |
| LogReuseWaitStatus |
string | LogReuseWaitStatus | LogReuseWaitStatus | false | 256 | 0 | False |
| DateCorrelationOptimization |
bool | DateCorrelationOptimization | DateCorrelationOptimization | false | 256 | 0 | |
| IsCDCEnabled |
bool | IsCDCEnabled | IsCDCEnabled | false | 256 | 0 | |
| EncryptionEnabled |
bool | EncryptionEnabled | EncryptionEnabled | false | 256 | 0 | |
| HonorBrokerPriority |
bool | HonorBrokerPriority | HonorBrokerPriority | false | 256 | 0 | |
| LocalCursorsDefault |
bool | LocalCursorsDefault | LocalCursorsDefault | false | 256 | 0 | |
| CloseCursorsOnCommitEnabled |
bool | CloseCursorsOnCommitEnabled | CloseCursorsOnCommitEnabled | false | 256 | 0 | |
| SupplementalLoggingEnabled |
bool | SupplimentalLoggingEnabled | IsSupplimentalLoggingEnabled | false | 256 | 0 | |
| EngineModelCollation |
string | EngineModelCollation | EngineModelCollation | false | 256 | 0 | False |
| IsSharepointDatabase |
bool | IsSharepointDatabase | IsSharepointDatabase | false | 256 | 0 | |
| IsSSRSDatabase |
bool | IsSSRSDatabase | IsSSRSDatabase | false | 256 | 0 | |
| IsSharepointSSRSSystemDatabase |
bool | IsSharepointSSRSSystemDatabase | IsSharepointSSRSSystemDatabase | false | 256 | 0 | |
| SystemCatalogUpdated |
bool | SystemCatalogUpdated | Is System Catalog Updated | false | 256 | 0 | |
| TargetRecoveryTimeInSeconds |
int | TargetRecoveryTimeInSeconds | Target Recovery Time In Seconds | false | 256 | 0 | |
| Containment |
int | Containment | Containment | false | 256 | 0 | |
| FiletableNonTransactedAccess |
int | FiletableNonTransactedAccess | File Table Non Transacted Access | false | 256 | 0 | |
| DataBaseGuid |
string | DataBaseGuid | DataBase Guid | false | 256 | 0 | False |
| FamilyGuid |
string | FamilyGuid | Family Guid | false | 256 | 0 | False |
Home
Show References: <ClassType ID="Microsoft.KnowledgeServices.SQLServer.Database" Accessibility="Public" Abstract="false" Base="SQL!Microsoft.SQLServer.Database" Hosted="true" Singleton="false">
<Property ID="DatabaseId" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0" Comment="Should be disabled"/>
<Property ID="PageVerify" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="Status" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsMirroringEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="MirroringRole" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="CreateDate" Type="datetime" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="CompatibilityLevel" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="ReadOnly" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="AutoClose" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="AutoShrink" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="StandBy" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="CleanlyShutdown" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="SnapshotIsolationState" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsReadCommittedSnapshotOn" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="AutoCreateStatisticsEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="AutoUpdateStatisticsEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="AutoUpdateStatisticsAsync" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="AnsiNullDefault" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="AnsiNullsEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="AnsiPaddingEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="AnsiWarningsEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="ArithmeticAbortEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="ConcatenateNullYieldsNull" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="NumericRoundAbortEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="QuotedIdentifiersEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="RecursiveTriggersEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsFullTextEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="Trustworthy" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="DatabaseOwnershipChaining" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsParameterizationForced" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsMasterKeyEncryptedByServer" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsPublished" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsSubscribed" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsMergePublished" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsDistributor" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsSyncWithBackup" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="BrokerEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="LogReuseWaitStatus" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="DateCorrelationOptimization" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsCDCEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="EncryptionEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="HonorBrokerPriority" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="LocalCursorsDefault" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="CloseCursorsOnCommitEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="SupplementalLoggingEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<!-- This really should be in DBEngine, but rules targeting KS.Database cannot access KS.DBEngine -->
<Property ID="EngineModelCollation" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsSharepointDatabase" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsSSRSDatabase" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="IsSharepointSSRSSystemDatabase" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<!--BEGIN : Edited by ericzha-->
<Property ID="SystemCatalogUpdated" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="TargetRecoveryTimeInSeconds" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="Containment" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="FiletableNonTransactedAccess" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<!--END : Edited by ericzha-->
<!--BEGIN: Edited by v-jobzha-->
<Property ID="DataBaseGuid" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<Property ID="FamilyGuid" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>
<!--END: Edited by v-jobzha-->
</ClassType>