Policy Management - Conditions

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.
 

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.
 

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.
 

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.
 

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.
 

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.
 

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.
 

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.
 

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.
 

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.
 
Top