Field | Description |
---|
@ActiveConnections | The number of active connections to the database. |
@AnsiNullDefault | Specifies whether the ANSI_NULL_DEFAULT database option is active. |
@AnsiNullsEnabled | Specifies whether the ANSI_NULLS_ENABLED database option is active. |
@AnsiPaddingEnabled | Specifies whether the ANSI_PADDING_ENABLED database option is active. |
@AnsiWarningsEnabled | Specifies whether the ANSI_WARNING_ENABLED database option is active. |
@ArithmeticAbortEnabled | Specifies whether the ARITHMETICABORT database option is active. |
@AutoClose | Specifies whether the AUTOCLOSE database option is active. |
@AutoCreateStatisticsEnabled | Specifies whether statistics are automatically created for the database. |
@AutoShrink | Specifies whether the AUTOSHRINK database option is active. |
@AutoUpdateStatisticsAsync | Specifies whether the AUTOUPDATESTATISTICSASYNC database option is active. |
@AutoUpdateStatisticsEnabled | Specifies whether statistics are automatically updated for the database. |
@BrokerEnabled | Specifies whether the Service Broker service is enabled. |
@CaseSensitive | Specifies whether uppercase letters and lowercase letters are evaluated as equal. |
@ChangeTrackingAutoCleanUp | Gets the Boolean property value that specifies whether change tracking data is automatically cleaned up after the configured retention period. |
@ChangeTrackingEnabled | Gets the Boolean property value that specifies whether change tracking is enabled. |
@ChangeTrackingRetentionPeriod | Gets the retention period specifying how long the change tracking data is kept in the database if autocleanup is being used. |
@ChangeTrackingRetentionPeriodUnits | Gets the unit of time for the change tracking retention period. |
@CloseCursorsOnCommitEnabled | Specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active. |
@Collation | The default collation used by the database. |
@CompatibilityLevel | The compatibility level for the database. |
@ConcatenateNullYieldsNull | Specifies whether the CONCAT_NULL_YIELDS_NULL database option is active. |
@CreateDate | The date that the database was created. |
@DatabaseGuid | The GUID value that uniquely identifies the database. |
@DatabaseOwnershipChaining | Specifies whether the database ownership chaining is active. |
@DatabaseSnapshotBaseName | The name of the snapshot base for the database. |
@DataSpaceUsage | The space used by the data in the database. |
@DateCorrelationOptimization | Specifies whether the date correlation optimization is active. |
@DboLogin | Specifies whether the current user is logged on as the database owner (DBO). |
@DefaultFileGroup | The default file group used by the database. |
@DefaultFileStreamFileGroup | Gets the filegroup name for the default FILESTREAM filegroup. |
@DefaultFullTextCatalog | The default full-text catalog used by the database. |
@DefaultSchema | The default schema of the user. |
@EncryptionEnabled | Gets the Boolean property value that specifies whether the database is enabled for transparent data encryption. |
@HonorBrokerPriority | Specifies whether the priority is taken into consideration for service broker. |
@ID | The database ID value that uniquely identifies the database. |
@IndexSpaceUsage | The space used by the indexes in the database. |
@IsAccessible | Specifies whether the database can be accessed. |
@IsDatabaseSnapshot | Specifies whether the database is a snapshot database. |
@IsDatabaseSnapshotBase | Specifies whether the database is the base database for a snapshot database. |
@IsDbAccessAdmin | Specifies whether the current user is a member of the DbAccessAdmin database role. |
@IsDbBackupOperator | Specifies whether the current user is a member of the DbBackupOperator database role. |
@IsDbDatareader | Specifies whether the current user is a member of the DbDatareader database role. |
@IsDbDataWriter | Specifies whether the current user is a member of the DbDatawriter database role. |
@IsDbDdlAdmin | Specifies whether the current user is a member of the DbDdlAdmin database role. |
@IsDbDenyDatareader | Specifies whether the current user is a member of the DbDenyDatareader database role. |
@IsDbDenyDatawriter | Specifies whether the current member is a member of the DbDenyDatawriter database. |
@IsDbOwner | Specifies whether the current user is a member of the DbOwner database role. |
@IsDbSecurityAdmin | Specifies whether the current user is a member of the DbSecurityAdmin database role. |
@IsFullTextEnabled | Specifies whether the database is enabled for full-text search. |
@IsMailHost | Specifies whether the database is configured as a mail host. |
@IsManagementDataWarehouse | Specifies whether the database is configured as a Management Data Warehouse. |
@IsMirroringEnabled | Specifies whether mirroring is enabled on the database. |
@IsParameterizationForced | Specifies whether parameterization is forced on the database. |
@IsReadCommittedSnapshotOn | Specifies whether the database is enabled for read-committed isolation using row versioning. |
@IsSystemObject | Specifies whether the database is a system object or a user-defined database. |
@IsUpdateable | Specifies whether the database can be updated. |
@IsVerDecimalStorageFormatEnabled | Specifies whether the database is enabled for vardecimal storage format. |
@LastBackupDate | The date and time when the database was last backed up. |
@LastDifferentialBackupDate | The date and time when the last differential backup was performed. |
@LastLogBackupDate | The date and time when the transaction log was last backed up. |
@LocalCursorsDefault | Specifies whether the local server cursors are used by default. |
@LogReuseWaitStatus | The type of operation on which the reuse of transaction log space is waiting. |
@MirroringFailoverLogSequenceNumber | The log sequence number at last failover. |
@MirroringID | The ID value that uniquely identifies the mirroring partnership. |
@MirroringPartner | The address of the Database Engine instance that is the partner server for database mirroring. |
@MirroringPartnerInstance | The instance of SQL Server on which the mirroring partner is configured. |
@MirroringRedoQueueMaxSize | The maximum size of the redo queue of the mirror server instance in KB. |
@MirroringRoleSequence | The role sequence number for primary/backup roles played by the mirroring partners. |
@MirroringSafetyLevel | The mirroring safety level. |
@MirroringSafetySequence | The role sequence number for safety levels for the mirroring partners. |
@MirroringStatus | The status of the database and the database mirroring session. |
@MirroringTimeout | The maximum time, in seconds, that the principal server instance waits for a PING message from another instance in the mirroring session before assuming the other instance is disconnected. |
@MirroringWitness | The name of the database-engine instance of the database mirroring witness server. |
@MirroringWitnessStatus | The status of the mirroring witness server. |
@Name | Gets or sets the name of the object.(inherited from NamedSmoObject) |
@NumericRoundAbortEnabled | Specifies whether the NUMERIC_ROUNDABORT database option is active. |
@Owner | The database principal that is the owner of the database. |
@PageVerify | Specifies the type of page integrity check that Microsoft SQL Server performs when reading database pages. |
@PrimaryFilePath | The path and name of the operating system directory that contains the primary file for the database. |
@QuotedIdentifiersEnabled | Specifies whether identifiers delimited by double quotation marks (" ") are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules. |
@ReadOnly | Specifies whether the database is read-only. |
@RecoveryForkGuid | The GUID value that specifies the recovery fork on which the database is currently active. |
@RecoveryModel | The recovery model for the database. |
@RecursiveTriggersEnabled | Specifies whether recursive triggers are enabled on the database. |
@ReplicationOptions | The active replication settings for a database, |
@ServiceBrokerGuid | The Guid object that uniquely identifies the instance of MicrosoftService Broker. |
@Size | The size of the database in megabytes. |
@SnapshotIsolationState | The snapshot isolation state for the database. |
@SpaceAvailable | The available space in the database in kilobytes. |
@Status | The database status. |
@Trustworthy | Specifies whether the trustworthy property is set. |
@UserAcces | The database user access. |
@UserName | The name of the database user. |
@Version | The version of the instance of SQL Server that was used to create the database. |