Policy Management - Conditions

[Peter Schmitz]

Policy Management allows you to define conditions on servers , and then select how you want to enforce them. I'll write a quick article on how to configure and install policy management soon, but for now figured I would start a thread to document the different facets, fields and descriptions.

I won't fill up a single thread with all of these in one time, but hope to be able to add more of them as time progresses.


Facet: Application Role

Field	Description
@CreateDate	The date and time when the application role was created.
@DateLastModified	The date and time when the application role was last modified.
@DefaultSchema	The default schema for the application role.
@ID	The ID value that uniquely identifies the application role.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject).

Facet: Asymetric Key

Field	Description
@ID	The ID value that uniquely identifies the asymetric key.
@KeyEncryptionAlgorithm	The encryption algorithm used to encrypt the asymetric key.
@Keylength	The length of the asymetric key.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject).
@Owner	The name of the database principal that is the owner of the asymetric key.
@PrivateKeyEncryptionType	The encryption type for the private key for the asymetric key.
@ProviderName	The provider name for the asymetric key.
@PublicKey	The public key for the asymetric key.
@Sid	The logon security identifier (SID) for the asymetric key.
@Thumbprint	The globally unique SHA-1 hash thumbprint for the asymetric key.

 

[Peter Schmitz]

Facet: Audit

Field	Description
@CreateDate	Is the date and time when the audit was created.
@DateLastModified	Is the date and time when the audit was last modified.
@DestinationType	Specifies the type of audit destination for the audit.
@Enabled	Is the Boolean property that specifies whether the audit is enabled.
@FileName	Is the file name of the audit destination when the audit destination is a file.
@FilePath	Specifies the file path of the audit when the audit destination is a file.
@Guid	Is the GUID value that uniquely identifies the audit.
@ID	Is the ID value that uniquely identifies the audit.
@MaximumFileSize	Gets or sets the value of maximum size to which the audit file can grow.
@MaximumFileSizeUnit	Gets or sets the unit of the maximum size to which the audit file can grow.
@MaximumRolloverFile	Specifies the maximum number of audit files to retain in the file system.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject).
@OnFailure	Specifiies the behavior of the audit when it fails to write the audit destination.
@QueueDelay	Specifies the amount of time in milliseconds that can elapse before audit actions are forced to be procesed.
@ReserveDiskSpace	Specifies the Boolean property that specifies that a if the file of MAXSIZE should be pre-created on the disk.

Facet: Backup Device

Field	Description
@BackupDeviceType	The type of backup device of te backup device.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject).
@PhysicalLocation	The path to the device or operating system file that represents the physical backup location.
@SkipTapeLabel	Specifies whether to check that the tape label is correct or not.

 

[Peter Schmitz]

Facet: Broker Priority

Field	Description
@ContractName	Name of a contract if the conversation priority applies to a conversation.
@ID	Gets the ID value that uniquely identifies the broker priority.
@LocalServiceName	Name of local service if the conversation priority applies to a conversation endpoint.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject).
@PriorityLevel	Priority level assigned to the priority.
@RemoteServiceName	Specifies the name of remote service if the conversation priority applies to a conversation endpoint.

Facet: Broker Service

Field	Description
@ID	Gets the ID value that uniquely identifies the broker service.
@IsSystemObject	Gets the Boolean property that specifies whether the message type is a system object.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject).
@Owner	The database principal that owns the Service Broker service.
@QueueName	Name of the queue that is used to receive messages sent to the service.
@QueueSchema	Name of the schema to which the queue belongs.

 

[Peter Schmitz]

Facet: Certificate

Field	Description
@ActiveForServiceBrokerDialog	Gets or sets the active for service broker dialog property of Certificate.
@ExpirationDate	Gets the expiration date property of Certificate.
@ID	Gets the ID value that uniquely identifies the Certificate.
@Issuer	Gets the issuer property of Certificate.
@LastBackupDate	Gets the date and time when the certificate was last backed up.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)
@Owner	Gets or sets the owner property of Certificate.
@PrivateKeyEncryptionType	Gets the private key encryption property of Certificate.
@Serial	Gets the serial property of Certificate.
@Sid	Gets the sid property of Certificate.
@StartDate	Gets start date property of Certificate.
@Subject	Gets start subject property of Certificate.
@Thumbprint	Gets the thumbprint property of Certificate.

Facet: Credential

Field	Description
@CreateDate	Gets the create date property of Credential.
@DateLastModified	Gets the date last modified property of Credential.
@ID	Gets the ID value that uniquely identifies the Credential.
@Identity	Gets or sets the identity property of Credential.
@MappedClassType	Gets the mapped class type property of Credential.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)
@ProviderName	Gets the provider name property of Credential.

 

[Peter Schmitz]

Facet: CryptographicProvider

Field	Description
@AsymetricKeyExportable	Gets the Boolean property that specifies if the Asymmetric keys created using the provider are exportable.
@AsymetricKeyImportable	Gets the Boolean property that specifies if the Asymmetric keys created using the provider are importable.
@AsymetricKeyPersistable	Gets the Boolean property that specifies if the Asymmetric keys created using the provider are persistable.
@AsymetricKeySupported	Gets the Boolean property that specifies if the Asymmetric keys can be created using the provider.
@AuthenticationType	Gets the authentication type supported by the provider.
@DllPath	Gets the dll path for the provider.
@Enabled	Gets or sets the Boolean property that specifies if the provider is enabled.
@ID	Gets the ID value that uniquely identifies the cryptographic provider.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)
@ProviderGuid	Gets the GUID value that uniquely identifies the cryptographic provider.
@SymmetricKeyExportable	Gets the Boolean property that specifies if the Symmetric keys created using the provider are exportable.
@SymmetricKeyImportable	Gets the Boolean property that specifies if the Symmetric keys created using the provider are importable.
@SymmetricKeyPersistable	Gets the Boolean property that specifies if the Symmetric keys created using the provider are persistable.
@SymmetricKeySupported	Gets the Boolean property that specifies if the Symmetric keys can be created using the provider.

Facet: Data File

Field	Description
@AvailableSpace	Gets the amount of available space in the data file in kilobytes.
@BytesReadFromDisk	Gets the total number of bytes read on the data file.
@BytesWrittenToDisk	Gets the total number of bytes written to the data file.
@FileName	Gets or sets the data file name.
@Growth	Gets or sets the growth increment for the data file in kilobytes or percent.
@GrowthType	Gets or sets the growth type for the data file in kilobytes or percent.
@ID	Gets the ID value that uniquely identifies the data file.
@IsOffline	Gets the Boolean property value that specifies whether the data file is offline or not.
@IsPrimaryFile	Gets the Boolean property value that specifies whether the data file is the primary file of the database.
@IsReadOnly	Gets the Boolean property value that specifies whether the data file is read-only or can be updated.
@IsReadOnlyMedia	Gets the Boolean property value that specifies whether the data file is stored on read-only media.
@IsSparse	Gets the Boolean value that specifies whether the data in the data file is sparse or dense.
@MaxSize	Gets or set the maximum size to which the data file can grow in kilobytes.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)
@NumberOfDiskReads	Gets the number of reads issued on the data file.
@NumberOfDiskWrites	Gets the number of writes made on the data file.
@Size	Gets or sets the current size of the data file in kilobytes.
@UsedSpace	Gets the amount of used space in the data file in kilobytes.
@VolumeFreeSpace	Gets the amount of free space available in KB of the volume that contains the data file.

 

[Peter Schmitz]

Facet: Database

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.

 

[Peter Schmitz]

Facet: Database Audit Specification

Field	Description
@AuditName	Specifies the audit name to which the database audit specification belongs.
@CreateDate	Is the date and time when the database audit specification was created.
@DateLastModified	Is the date and time when the database audit specification was last modified.
@Enabled	Specifies the Boolean property that specifies whether the database audit specification is enabled.
@Guid	Is the GUID value of the audit to which the database audit specification belongs.
@ID	Is the ID value that uniquely identifies the database audit specification.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)

Facet: Database DDL Trigger

Field	Description
@AnsiNullStatus	Gets or sets the Boolean property value that specifies whether SQL-92 NULL handling is enabled in the data definition language (DDL) trigger.
@AssemblyName	Gets or sets the name of the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.
@BodyStartIndex	Gets the index value that represents the start of the DDL trigger text body.
@ClassName	Gets or sets the name of the class in the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.
@CreateDate	Gets the date and time when the database data definition language (DDL) trigger was created.
@DateLastModified	Gets the date and time when the database data definition language (DDL) trigger was last modified.
@ExecutionContext	Gets the execution conext of the DDL trigger.
@ExecutionContextUser	Gets the execution conext user for the DDL trigger.
@ID	Gets the ID value that uniquely identifies the database data definition language (DDL) trigger.
@ImplementationType	Gets or sets the implementation type for the database data definition language (DDL) trigger.
@IsEnabled	Gets the Boolean property value that specifies whether the database data definition language (DDL) trigger is enabled.
@IsEncrypted	Gets or sets a Boolean property value that specifies whether the Transact-SQL batch or managed code is encrypted.
@IsSystemObject	Gets the Boolean property value that specifies whether the database data definition language (DDL) trigger is a system object.
@MethodName	Gets or sets the name of the method that is owned by the class in the assembly, which is executed when the trigger is raised.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)
@NotForReplication	Gets or sets a Boolean property value that specifies whether the database data definition language (DDL) trigger is available for replication.
@QuotedIdentifierStatus	Gets or sets a Boolean property value that 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.
@Text	Gets the Transact-SQL statement that defines the database data definition language (DDL) trigger.

 

[Peter Schmitz]

Facet: Database Audit Specification

Field	Description
@AuditName	Specifies the audit name to which the database audit specification belongs.
@CreateDate	Is the date and time when the database audit specification was created.
@DateLastModified	Is the date and time when the database audit specification was last modified.
@Enabled	Specifies the Boolean property that specifies whether the database audit specification is enabled.
@Guid	Is the GUID value of the audit to which the database audit specification belongs.
@ID	Is the ID value that uniquely identifies the database audit specification.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)

Facet: Database DDL Trigger

Field	Description
@AnsiNullStatus	Gets or sets the Boolean property value that specifies whether SQL-92 NULL handling is enabled in the data definition language (DDL) trigger.
@AssemblyName	Gets or sets the name of the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.
@BodyStartIndex	Gets the index value that represents the start of the DDL trigger text body.
@ClassName	Gets or sets the name of the class in the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.
@CreateDate	Gets the date and time when the database data definition language (DDL) trigger was created.
@DateLastModified	Gets the date and time when the database data definition language (DDL) trigger was last modified.
@ExecutionContext	Gets the execution conext of the DDL trigger.
@ExecutionContextUser	Gets the execution conext user for the DDL trigger.
@ID	Gets the ID value that uniquely identifies the database data definition language (DDL) trigger.
@ImplementationType	Gets or sets the implementation type for the database data definition language (DDL) trigger.
@IsEnabled	Gets the Boolean property value that specifies whether the database data definition language (DDL) trigger is enabled.
@IsEncrypted	Gets or sets a Boolean property value that specifies whether the Transact-SQL batch or managed code is encrypted.
@IsSystemObject	Gets the Boolean property value that specifies whether the database data definition language (DDL) trigger is a system object.
@MethodName	Gets or sets the name of the method that is owned by the class in the assembly, which is executed when the trigger is raised.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)
@NotForReplication	Gets or sets a Boolean property value that specifies whether the database data definition language (DDL) trigger is available for replication.
@QuotedIdentifierStatus	Gets or sets a Boolean property value that 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.
@Text	Gets the Transact-SQL statement that defines the database data definition language (DDL) trigger.

Facet: Database Maintenance

Field	Description
@DataAndBackupOnSeperateLogicalVolumes	Returns true if the database has its data and backup files on the separate logical volumes.
@LastBackupDate	The date and time when the database was last backed up.
@LastLogBackupDate	The date and time when the transaction log was last backed up.
@PageVerify	Specifies the type of page integrity check that Microsoft SQL Server performs when reading database pages.
@ReadOnly	Specifies whether the database is read-only.
@RecoveryModel	The recovery model for the database.
@Status	The database status.

 

[Peter Schmitz]

Facet: Database Audit Specification

Field	Description
@AuditName	Specifies the audit name to which the database audit specification belongs.
@CreateDate	Is the date and time when the database audit specification was created.
@DateLastModified	Is the date and time when the database audit specification was last modified.
@Enabled	Specifies the Boolean property that specifies whether the database audit specification is enabled.
@Guid	Is the GUID value of the audit to which the database audit specification belongs.
@ID	Is the ID value that uniquely identifies the database audit specification.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)

Facet: Database DDL Trigger

Field	Description
@AnsiNullStatus	Gets or sets the Boolean property value that specifies whether SQL-92 NULL handling is enabled in the data definition language (DDL) trigger.
@AssemblyName	Gets or sets the name of the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.
@BodyStartIndex	Gets the index value that represents the start of the DDL trigger text body.
@ClassName	Gets or sets the name of the class in the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.
@CreateDate	Gets the date and time when the database data definition language (DDL) trigger was created.
@DateLastModified	Gets the date and time when the database data definition language (DDL) trigger was last modified.
@ExecutionContext	Gets the execution conext of the DDL trigger.
@ExecutionContextUser	Gets the execution conext user for the DDL trigger.
@ID	Gets the ID value that uniquely identifies the database data definition language (DDL) trigger.
@ImplementationType	Gets or sets the implementation type for the database data definition language (DDL) trigger.
@IsEnabled	Gets the Boolean property value that specifies whether the database data definition language (DDL) trigger is enabled.
@IsEncrypted	Gets or sets a Boolean property value that specifies whether the Transact-SQL batch or managed code is encrypted.
@IsSystemObject	Gets the Boolean property value that specifies whether the database data definition language (DDL) trigger is a system object.
@MethodName	Gets or sets the name of the method that is owned by the class in the assembly, which is executed when the trigger is raised.
@Name	Gets or sets the name of the object.(inherited from NamedSmoObject)
@NotForReplication	Gets or sets a Boolean property value that specifies whether the database data definition language (DDL) trigger is available for replication.
@QuotedIdentifierStatus	Gets or sets a Boolean property value that 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.
@Text	Gets the Transact-SQL statement that defines the database data definition language (DDL) trigger.

 

[Peter Schmitz]

Facet: Database Maintenance

Field	Description
@DataAndBackupOnSeperateLogicalVolumes	Returns true if the database has its data and backup files on the separate logical volumes.
@LastBackupDate	The date and time when the database was last backed up.
@LastLogBackupDate	The date and time when the transaction log was last backed up.
@PageVerify	Specifies the type of page integrity check that Microsoft SQL Server performs when reading database pages.
@ReadOnly	Specifies whether the database is read-only.
@RecoveryModel	The recovery model for the database.
@Status	The database status.

Facet: Database Options

Field	Description
@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.
@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.
@DatabaseOwnershipChaining	Specifies whether the database ownership chaining is active.
@DatabaseSnapshotBaseName	The name of the snapshot base for the database.
@DateCorrelationOptimization	Specifies whether the date correlation optimization is active.
@DefaultFileGroup	The default file group used by the database.
@DefaultFileStreamFileGroup	Gets the filegroup name for the default FILESTREAM filegroup.
@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.
@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.
@IsUpdatable	Specifies whether the database can be updated.
@LocalCursorsDefault	Specifies whether the local server cursors are used by default.
@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.
@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.
@ReceoveryModel	The recovery model for the database.
@RecursiveTriggersEnabled	Specifies whether recursive triggers are enabled on the database.
@Trustworthy	Specifies whether the trustworthy property is set.
@UserAccess	The database user access.