Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Policy Management - Conditions

Discussion in 'Installation and Administration' started by Peter Schmitz, Oct 1, 2012.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    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

    FieldDescription
    @CreateDateThe date and time when the application role was created.
    @DateLastModifiedThe date and time when the application role was last modified.
    @DefaultSchemaThe default schema for the application role.
    @IDThe ID value that uniquely identifies the application role.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject).


    Facet: Asymetric Key

    FieldDescription
    @IDThe ID value that uniquely identifies the asymetric key.
    @KeyEncryptionAlgorithmThe encryption algorithm used to encrypt the asymetric key.
    @KeylengthThe length of the asymetric key.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject).
    @OwnerThe name of the database principal that is the owner of the asymetric key.
    @PrivateKeyEncryptionTypeThe encryption type for the private key for the asymetric key.
    @ProviderNameThe provider name for the asymetric key.
    @PublicKeyThe public key for the asymetric key.
    @SidThe logon security identifier (SID) for the asymetric key.
    @ThumbprintThe globally unique SHA-1 hash thumbprint for the asymetric key.
  2. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Facet: Audit

    FieldDescription
    @CreateDateIs the date and time when the audit was created.
    @DateLastModifiedIs the date and time when the audit was last modified.
    @DestinationTypeSpecifies the type of audit destination for the audit.
    @EnabledIs the Boolean property that specifies whether the audit is enabled.
    @FileNameIs the file name of the audit destination when the audit destination is a file.
    @FilePathSpecifies the file path of the audit when the audit destination is a file.
    @GuidIs the GUID value that uniquely identifies the audit.
    @IDIs the ID value that uniquely identifies the audit.
    @MaximumFileSizeGets or sets the value of maximum size to which the audit file can grow.
    @MaximumFileSizeUnitGets or sets the unit of the maximum size to which the audit file can grow.
    @MaximumRolloverFileSpecifies the maximum number of audit files to retain in the file system.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject).
    @OnFailureSpecifiies the behavior of the audit when it fails to write the audit destination.
    @QueueDelaySpecifies the amount of time in milliseconds that can elapse before audit actions are forced to be procesed.
    @ReserveDiskSpaceSpecifies the Boolean property that specifies that a if the file of MAXSIZE should be pre-created on the disk.


    Facet: Backup Device

    FieldDescription
    @BackupDeviceTypeThe type of backup device of te backup device.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject).
    @PhysicalLocationThe path to the device or operating system file that represents the physical backup location.
    @SkipTapeLabelSpecifies whether to check that the tape label is correct or not.
  3. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Facet: Broker Priority

    FieldDescription
    @ContractNameName of a contract if the conversation priority applies to a conversation.
    @IDGets the ID value that uniquely identifies the broker priority.
    @LocalServiceNameName of local service if the conversation priority applies to a conversation endpoint.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject).
    @PriorityLevelPriority level assigned to the priority.
    @RemoteServiceNameSpecifies the name of remote service if the conversation priority applies to a conversation endpoint.


    Facet: Broker Service

    FieldDescription
    @IDGets the ID value that uniquely identifies the broker service.
    @IsSystemObjectGets the Boolean property that specifies whether the message type is a system object.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject).
    @OwnerThe database principal that owns the Service Broker service.
    @QueueNameName of the queue that is used to receive messages sent to the service.
    @QueueSchemaName of the schema to which the queue belongs.
  4. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Facet: Certificate

    FieldDescription
    @ActiveForServiceBrokerDialogGets or sets the active for service broker dialog property of Certificate.
    @ExpirationDateGets the expiration date property of Certificate.
    @IDGets the ID value that uniquely identifies the Certificate.
    @IssuerGets the issuer property of Certificate.
    @LastBackupDateGets the date and time when the certificate was last backed up.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)
    @OwnerGets or sets the owner property of Certificate.
    @PrivateKeyEncryptionTypeGets the private key encryption property of Certificate.
    @SerialGets the serial property of Certificate.
    @SidGets the sid property of Certificate.
    @StartDateGets start date property of Certificate.
    @SubjectGets start subject property of Certificate.
    @ThumbprintGets the thumbprint property of Certificate.


    Facet: Credential

    FieldDescription
    @CreateDateGets the create date property of Credential.
    @DateLastModifiedGets the date last modified property of Credential.
    @IDGets the ID value that uniquely identifies the Credential.
    @IdentityGets or sets the identity property of Credential.
    @MappedClassTypeGets the mapped class type property of Credential.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)
    @ProviderNameGets the provider name property of Credential.
  5. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Facet: CryptographicProvider

    FieldDescription
    @AsymetricKeyExportableGets the Boolean property that specifies if the Asymmetric keys created using the provider are exportable.
    @AsymetricKeyImportableGets the Boolean property that specifies if the Asymmetric keys created using the provider are importable.
    @AsymetricKeyPersistableGets the Boolean property that specifies if the Asymmetric keys created using the provider are persistable.
    @AsymetricKeySupportedGets the Boolean property that specifies if the Asymmetric keys can be created using the provider.
    @AuthenticationTypeGets the authentication type supported by the provider.
    @DllPathGets the dll path for the provider.
    @EnabledGets or sets the Boolean property that specifies if the provider is enabled.
    @IDGets the ID value that uniquely identifies the cryptographic provider.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)
    @ProviderGuidGets the GUID value that uniquely identifies the cryptographic provider.
    @SymmetricKeyExportableGets the Boolean property that specifies if the Symmetric keys created using the provider are exportable.
    @SymmetricKeyImportableGets the Boolean property that specifies if the Symmetric keys created using the provider are importable.
    @SymmetricKeyPersistableGets the Boolean property that specifies if the Symmetric keys created using the provider are persistable.
    @SymmetricKeySupportedGets the Boolean property that specifies if the Symmetric keys can be created using the provider.


    Facet: Data File

    FieldDescription
    @AvailableSpaceGets the amount of available space in the data file in kilobytes.
    @BytesReadFromDiskGets the total number of bytes read on the data file.
    @BytesWrittenToDiskGets the total number of bytes written to the data file.
    @FileNameGets or sets the data file name.
    @GrowthGets or sets the growth increment for the data file in kilobytes or percent.
    @GrowthTypeGets or sets the growth type for the data file in kilobytes or percent.
    @IDGets the ID value that uniquely identifies the data file.
    @IsOfflineGets the Boolean property value that specifies whether the data file is offline or not.
    @IsPrimaryFileGets the Boolean property value that specifies whether the data file is the primary file of the database.
    @IsReadOnlyGets the Boolean property value that specifies whether the data file is read-only or can be updated.
    @IsReadOnlyMediaGets the Boolean property value that specifies whether the data file is stored on read-only media.
    @IsSparseGets the Boolean value that specifies whether the data in the data file is sparse or dense.
    @MaxSizeGets or set the maximum size to which the data file can grow in kilobytes.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)
    @NumberOfDiskReadsGets the number of reads issued on the data file.
    @NumberOfDiskWritesGets the number of writes made on the data file.
    @SizeGets or sets the current size of the data file in kilobytes.
    @UsedSpaceGets the amount of used space in the data file in kilobytes.
    @VolumeFreeSpaceGets the amount of free space available in KB of the volume that contains the data file.
  6. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Facet: Database

    FieldDescription
    @ActiveConnectionsThe number of active connections to the database.
    @AnsiNullDefaultSpecifies whether the ANSI_NULL_DEFAULT database option is active.
    @AnsiNullsEnabledSpecifies whether the ANSI_NULLS_ENABLED database option is active.
    @AnsiPaddingEnabledSpecifies whether the ANSI_PADDING_ENABLED database option is active.
    @AnsiWarningsEnabledSpecifies whether the ANSI_WARNING_ENABLED database option is active.
    @ArithmeticAbortEnabledSpecifies whether the ARITHMETICABORT database option is active.
    @AutoCloseSpecifies whether the AUTOCLOSE database option is active.
    @AutoCreateStatisticsEnabledSpecifies whether statistics are automatically created for the database.
    @AutoShrinkSpecifies whether the AUTOSHRINK database option is active.
    @AutoUpdateStatisticsAsyncSpecifies whether the AUTOUPDATESTATISTICSASYNC database option is active.
    @AutoUpdateStatisticsEnabledSpecifies whether statistics are automatically updated for the database.
    @BrokerEnabledSpecifies whether the Service Broker service is enabled.
    @CaseSensitiveSpecifies whether uppercase letters and lowercase letters are evaluated as equal.
    @ChangeTrackingAutoCleanUpGets the Boolean property value that specifies whether change tracking data is automatically cleaned up after the configured retention period.
    @ChangeTrackingEnabledGets the Boolean property value that specifies whether change tracking is enabled.
    @ChangeTrackingRetentionPeriodGets the retention period specifying how long the change tracking data is kept in the database if autocleanup is being used.
    @ChangeTrackingRetentionPeriodUnitsGets the unit of time for the change tracking retention period.
    @CloseCursorsOnCommitEnabledSpecifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.
    @CollationThe default collation used by the database.
    @CompatibilityLevelThe compatibility level for the database.
    @ConcatenateNullYieldsNullSpecifies whether the CONCAT_NULL_YIELDS_NULL database option is active.
    @CreateDateThe date that the database was created.
    @DatabaseGuidThe GUID value that uniquely identifies the database.
    @DatabaseOwnershipChainingSpecifies whether the database ownership chaining is active.
    @DatabaseSnapshotBaseNameThe name of the snapshot base for the database.
    @DataSpaceUsageThe space used by the data in the database.
    @DateCorrelationOptimizationSpecifies whether the date correlation optimization is active.
    @DboLoginSpecifies whether the current user is logged on as the database owner (DBO).
    @DefaultFileGroupThe default file group used by the database.
    @DefaultFileStreamFileGroupGets the filegroup name for the default FILESTREAM filegroup.
    @DefaultFullTextCatalogThe default full-text catalog used by the database.
    @DefaultSchemaThe default schema of the user.
    @EncryptionEnabledGets the Boolean property value that specifies whether the database is enabled for transparent data encryption.
    @HonorBrokerPrioritySpecifies whether the priority is taken into consideration for service broker.
    @IDThe database ID value that uniquely identifies the database.
    @IndexSpaceUsageThe space used by the indexes in the database.
    @IsAccessibleSpecifies whether the database can be accessed.
    @IsDatabaseSnapshotSpecifies whether the database is a snapshot database.
    @IsDatabaseSnapshotBaseSpecifies whether the database is the base database for a snapshot database.
    @IsDbAccessAdminSpecifies whether the current user is a member of the DbAccessAdmin database role.
    @IsDbBackupOperatorSpecifies whether the current user is a member of the DbBackupOperator database role.
    @IsDbDatareaderSpecifies whether the current user is a member of the DbDatareader database role.
    @IsDbDataWriterSpecifies whether the current user is a member of the DbDatawriter database role.
    @IsDbDdlAdminSpecifies whether the current user is a member of the DbDdlAdmin database role.
    @IsDbDenyDatareaderSpecifies whether the current user is a member of the DbDenyDatareader database role.
    @IsDbDenyDatawriterSpecifies whether the current member is a member of the DbDenyDatawriter database.
    @IsDbOwnerSpecifies whether the current user is a member of the DbOwner database role.
    @IsDbSecurityAdminSpecifies whether the current user is a member of the DbSecurityAdmin database role.
    @IsFullTextEnabledSpecifies whether the database is enabled for full-text search.
    @IsMailHostSpecifies whether the database is configured as a mail host.
    @IsManagementDataWarehouseSpecifies whether the database is configured as a Management Data Warehouse.
    @IsMirroringEnabledSpecifies whether mirroring is enabled on the database.
    @IsParameterizationForcedSpecifies whether parameterization is forced on the database.
    @IsReadCommittedSnapshotOnSpecifies whether the database is enabled for read-committed isolation using row versioning.
    @IsSystemObjectSpecifies whether the database is a system object or a user-defined database.
    @IsUpdateableSpecifies whether the database can be updated.
    @IsVerDecimalStorageFormatEnabledSpecifies whether the database is enabled for vardecimal storage format.
    @LastBackupDateThe date and time when the database was last backed up.
    @LastDifferentialBackupDateThe date and time when the last differential backup was performed.
    @LastLogBackupDateThe date and time when the transaction log was last backed up.
    @LocalCursorsDefaultSpecifies whether the local server cursors are used by default.
    @LogReuseWaitStatusThe type of operation on which the reuse of transaction log space is waiting.
    @MirroringFailoverLogSequenceNumberThe log sequence number at last failover.
    @MirroringIDThe ID value that uniquely identifies the mirroring partnership.
    @MirroringPartnerThe address of the Database Engine instance that is the partner server for database mirroring.
    @MirroringPartnerInstanceThe instance of SQL Server on which the mirroring partner is configured.
    @MirroringRedoQueueMaxSizeThe maximum size of the redo queue of the mirror server instance in KB.
    @MirroringRoleSequenceThe role sequence number for primary/backup roles played by the mirroring partners.
    @MirroringSafetyLevelThe mirroring safety level.
    @MirroringSafetySequenceThe role sequence number for safety levels for the mirroring partners.
    @MirroringStatusThe status of the database and the database mirroring session.
    @MirroringTimeoutThe 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.
    @MirroringWitnessThe name of the database-engine instance of the database mirroring witness server.
    @MirroringWitnessStatusThe status of the mirroring witness server.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)
    @NumericRoundAbortEnabledSpecifies whether the NUMERIC_ROUNDABORT database option is active.
    @OwnerThe database principal that is the owner of the database.
    @PageVerifySpecifies the type of page integrity check that Microsoft SQL Server performs when reading database pages.
    @PrimaryFilePathThe path and name of the operating system directory that contains the primary file for the database.
    @QuotedIdentifiersEnabledSpecifies whether identifiers delimited by double quotation marks (" ") are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.
    @ReadOnlySpecifies whether the database is read-only.
    @RecoveryForkGuidThe GUID value that specifies the recovery fork on which the database is currently active.
    @RecoveryModelThe recovery model for the database.
    @RecursiveTriggersEnabledSpecifies whether recursive triggers are enabled on the database.
    @ReplicationOptionsThe active replication settings for a database,
    @ServiceBrokerGuidThe Guid object that uniquely identifies the instance of MicrosoftService Broker.
    @SizeThe size of the database in megabytes.
    @SnapshotIsolationStateThe snapshot isolation state for the database.
    @SpaceAvailableThe available space in the database in kilobytes.
    @StatusThe database status.
    @TrustworthySpecifies whether the trustworthy property is set.
    @UserAccesThe database user access.
    @UserNameThe name of the database user.
    @VersionThe version of the instance of SQL Server that was used to create the database.
  7. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Facet: Database Audit Specification

    FieldDescription
    @AuditNameSpecifies the audit name to which the database audit specification belongs.
    @CreateDateIs the date and time when the database audit specification was created.
    @DateLastModifiedIs the date and time when the database audit specification was last modified.
    @EnabledSpecifies the Boolean property that specifies whether the database audit specification is enabled.
    @GuidIs the GUID value of the audit to which the database audit specification belongs.
    @IDIs the ID value that uniquely identifies the database audit specification.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)


    Facet: Database DDL Trigger

    FieldDescription
    @AnsiNullStatusGets or sets the Boolean property value that specifies whether SQL-92 NULL handling is enabled in the data definition language (DDL) trigger.
    @AssemblyNameGets or sets the name of the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.
    @BodyStartIndexGets the index value that represents the start of the DDL trigger text body.
    @ClassNameGets 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.
    @CreateDateGets the date and time when the database data definition language (DDL) trigger was created.
    @DateLastModifiedGets the date and time when the database data definition language (DDL) trigger was last modified.
    @ExecutionContextGets the execution conext of the DDL trigger.
    @ExecutionContextUserGets the execution conext user for the DDL trigger.
    @IDGets the ID value that uniquely identifies the database data definition language (DDL) trigger.
    @ImplementationTypeGets or sets the implementation type for the database data definition language (DDL) trigger.
    @IsEnabledGets the Boolean property value that specifies whether the database data definition language (DDL) trigger is enabled.
    @IsEncryptedGets or sets a Boolean property value that specifies whether the Transact-SQL batch or managed code is encrypted.
    @IsSystemObjectGets the Boolean property value that specifies whether the database data definition language (DDL) trigger is a system object.
    @MethodNameGets or sets the name of the method that is owned by the class in the assembly, which is executed when the trigger is raised.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)
    @NotForReplicationGets or sets a Boolean property value that specifies whether the database data definition language (DDL) trigger is available for replication.
    @QuotedIdentifierStatusGets 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.
    @TextGets the Transact-SQL statement that defines the database data definition language (DDL) trigger.
  8. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Facet: Database Audit Specification

    FieldDescription
    @AuditNameSpecifies the audit name to which the database audit specification belongs.
    @CreateDateIs the date and time when the database audit specification was created.
    @DateLastModifiedIs the date and time when the database audit specification was last modified.
    @EnabledSpecifies the Boolean property that specifies whether the database audit specification is enabled.
    @GuidIs the GUID value of the audit to which the database audit specification belongs.
    @IDIs the ID value that uniquely identifies the database audit specification.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)


    Facet: Database DDL Trigger

    FieldDescription
    @AnsiNullStatusGets or sets the Boolean property value that specifies whether SQL-92 NULL handling is enabled in the data definition language (DDL) trigger.
    @AssemblyNameGets or sets the name of the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.
    @BodyStartIndexGets the index value that represents the start of the DDL trigger text body.
    @ClassNameGets 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.
    @CreateDateGets the date and time when the database data definition language (DDL) trigger was created.
    @DateLastModifiedGets the date and time when the database data definition language (DDL) trigger was last modified.
    @ExecutionContextGets the execution conext of the DDL trigger.
    @ExecutionContextUserGets the execution conext user for the DDL trigger.
    @IDGets the ID value that uniquely identifies the database data definition language (DDL) trigger.
    @ImplementationTypeGets or sets the implementation type for the database data definition language (DDL) trigger.
    @IsEnabledGets the Boolean property value that specifies whether the database data definition language (DDL) trigger is enabled.
    @IsEncryptedGets or sets a Boolean property value that specifies whether the Transact-SQL batch or managed code is encrypted.
    @IsSystemObjectGets the Boolean property value that specifies whether the database data definition language (DDL) trigger is a system object.
    @MethodNameGets or sets the name of the method that is owned by the class in the assembly, which is executed when the trigger is raised.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)
    @NotForReplicationGets or sets a Boolean property value that specifies whether the database data definition language (DDL) trigger is available for replication.
    @QuotedIdentifierStatusGets 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.
    @TextGets the Transact-SQL statement that defines the database data definition language (DDL) trigger.


    Facet: Database Maintenance

    FieldDescription
    @DataAndBackupOnSeperateLogicalVolumesReturns true if the database has its data and backup files on the separate logical volumes.
    @LastBackupDateThe date and time when the database was last backed up.
    @LastLogBackupDateThe date and time when the transaction log was last backed up.
    @PageVerifySpecifies the type of page integrity check that Microsoft SQL Server performs when reading database pages.
    @ReadOnlySpecifies whether the database is read-only.
    @RecoveryModelThe recovery model for the database.
    @StatusThe database status.
  9. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Facet: Database Audit Specification

    FieldDescription
    @AuditNameSpecifies the audit name to which the database audit specification belongs.
    @CreateDateIs the date and time when the database audit specification was created.
    @DateLastModifiedIs the date and time when the database audit specification was last modified.
    @EnabledSpecifies the Boolean property that specifies whether the database audit specification is enabled.
    @GuidIs the GUID value of the audit to which the database audit specification belongs.
    @IDIs the ID value that uniquely identifies the database audit specification.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)


    Facet: Database DDL Trigger

    FieldDescription
    @AnsiNullStatusGets or sets the Boolean property value that specifies whether SQL-92 NULL handling is enabled in the data definition language (DDL) trigger.
    @AssemblyNameGets or sets the name of the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.
    @BodyStartIndexGets the index value that represents the start of the DDL trigger text body.
    @ClassNameGets 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.
    @CreateDateGets the date and time when the database data definition language (DDL) trigger was created.
    @DateLastModifiedGets the date and time when the database data definition language (DDL) trigger was last modified.
    @ExecutionContextGets the execution conext of the DDL trigger.
    @ExecutionContextUserGets the execution conext user for the DDL trigger.
    @IDGets the ID value that uniquely identifies the database data definition language (DDL) trigger.
    @ImplementationTypeGets or sets the implementation type for the database data definition language (DDL) trigger.
    @IsEnabledGets the Boolean property value that specifies whether the database data definition language (DDL) trigger is enabled.
    @IsEncryptedGets or sets a Boolean property value that specifies whether the Transact-SQL batch or managed code is encrypted.
    @IsSystemObjectGets the Boolean property value that specifies whether the database data definition language (DDL) trigger is a system object.
    @MethodNameGets or sets the name of the method that is owned by the class in the assembly, which is executed when the trigger is raised.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)
    @NotForReplicationGets or sets a Boolean property value that specifies whether the database data definition language (DDL) trigger is available for replication.
    @QuotedIdentifierStatusGets 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.
    @TextGets the Transact-SQL statement that defines the database data definition language (DDL) trigger.
  10. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Facet: Database Maintenance

    FieldDescription
    @DataAndBackupOnSeperateLogicalVolumesReturns true if the database has its data and backup files on the separate logical volumes.
    @LastBackupDateThe date and time when the database was last backed up.
    @LastLogBackupDateThe date and time when the transaction log was last backed up.
    @PageVerifySpecifies the type of page integrity check that Microsoft SQL Server performs when reading database pages.
    @ReadOnlySpecifies whether the database is read-only.
    @RecoveryModelThe recovery model for the database.
    @StatusThe database status.


    Facet: Database Options

    FieldDescription
    @AnsiNullDefaultSpecifies whether the ANSI_NULL_DEFAULT database option is active.
    @AnsiNullsEnabledSpecifies whether the ANSI_NULLS_ENABLED database option is active.
    @AnsiPaddingEnabledSpecifies whether the ANSI_PADDING_ENABLED database option is active.
    @AnsiWarningsEnabledSpecifies whether the ANSI_WARNING_ENABLED database option is active.
    @ArithmeticAbortEnabledSpecifies whether the ARITHMETICABORT database option is active.
    @AutoCloseSpecifies whether the AUTOCLOSE database option is active.
    @AutoCreateStatisticsEnabledSpecifies whether statistics are automatically created for the database.
    @AutoShrinkSpecifies whether the AUTOSHRINK database option is active.
    @AutoUpdateStatisticsAsyncSpecifies whether the AUTOUPDATESTATISTICSASYNC database option is active.
    @AutoUpdateStatisticsEnabledSpecifies whether statistics are automatically updated for the database.
    @BrokerEnabledSpecifies whether the Service Broker service is enabled.
    @ChangeTrackingAutoCleanupGets the Boolean property value that specifies whether change tracking data is automatically cleaned up after the configured retention period.
    @ChangeTrackingEnabledGets the Boolean property value that specifies whether change tracking is enabled.
    @ChangeTrackingRetentionPeriodGets the retention period specifying how long the change tracking data is kept in the database if autocleanup is being used.
    @ChangeTrackingRetentionPeriodUnitsGets the unit of time for the change tracking retention period.
    @CloseCursorsOnCommitEnabledSpecifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.
    @CollationThe default collation used by the database.
    @CompatibilityLevelThe compatibility level for the database.
    @ConcatenateNullYieldsNullSpecifies whether the CONCAT_NULL_YIELDS_NULL database option is active.
    @CreateDateThe date that the database was created.
    @DatabaseOwnershipChainingSpecifies whether the database ownership chaining is active.
    @DatabaseSnapshotBaseNameThe name of the snapshot base for the database.
    @DateCorrelationOptimizationSpecifies whether the date correlation optimization is active.
    @DefaultFileGroupThe default file group used by the database.
    @DefaultFileStreamFileGroupGets the filegroup name for the default FILESTREAM filegroup.
    @EncryptionEnabledGets the Boolean property value that specifies whether the database is enabled for transparent data encryption.
    @HonorBrokerPrioritySpecifies whether the priority is taken into consideration for service broker.
    @IDThe database ID value that uniquely identifies the database.
    @IsParameterizationForcedSpecifies whether parameterization is forced on the database.
    @IsReadCommittedSnapshotOnSpecifies whether the database is enabled for read-committed isolation using row versioning.
    @IsSystemObjectSpecifies whether the database is a system object or a user-defined database.
    @IsUpdatableSpecifies whether the database can be updated.
    @LocalCursorsDefaultSpecifies whether the local server cursors are used by default.
    @MirroringTimeoutThe 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.
    @NameGets or sets the name of the object.(inherited from NamedSmoObject)
    @NumericRoundAbortEnabledSpecifies whether the NUMERIC_ROUNDABORT database option is active.
    @OwnerThe database principal that is the owner of the database.
    @PageVerifySpecifies the type of page integrity check that Microsoft SQL Server performs when reading database pages.
    @PrimaryFilePathThe path and name of the operating system directory that contains the primary file for the database.
    @QuotedIdentifiersEnabledSpecifies whether identifiers delimited by double quotation marks (" ") are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.
    @ReadOnlySpecifies whether the database is read-only.
    @ReceoveryModelThe recovery model for the database.
    @RecursiveTriggersEnabledSpecifies whether recursive triggers are enabled on the database.
    @TrustworthySpecifies whether the trustworthy property is set.
    @UserAccessThe database user access.

Share This Page