Test‑SqlDscDatabaseProperty - dsccommunity/SqlServerDsc GitHub Wiki
Tests if database properties on a SQL Server Database Engine instance are in the desired state.
Test-SqlDscDatabaseProperty -ServerObject <Server> -Name <String> [-Refresh]
[-AcceleratedRecoveryEnabled <Boolean>] [-ActiveDirectory <Boolean>] [-AnsiNullDefault <Boolean>]
[-AnsiNullsEnabled <Boolean>] [-AnsiPaddingEnabled <Boolean>] [-AnsiWarningsEnabled <Boolean>]
[-ArithmeticAbortEnabled <Boolean>] [-AutoClose <Boolean>] [-AutoCreateIncrementalStatisticsEnabled <Boolean>]
[-AutoCreateStatisticsEnabled <Boolean>] [-AutoShrink <Boolean>] [-AutoUpdateStatisticsAsync <Boolean>]
[-AutoUpdateStatisticsEnabled <Boolean>] [-BrokerEnabled <Boolean>] [-CaseSensitive <Boolean>]
[-ChangeTrackingAutoCleanUp <Boolean>] [-ChangeTrackingEnabled <Boolean>]
[-CloseCursorsOnCommitEnabled <Boolean>] [-ConcatenateNullYieldsNull <Boolean>]
[-DatabaseOwnershipChaining <Boolean>] [-DataRetentionEnabled <Boolean>]
[-DateCorrelationOptimization <Boolean>] [-DelayedDurability <Boolean>] [-EncryptionEnabled <Boolean>]
[-HasDatabaseEncryptionKey <Boolean>] [-HasFileInCloud <Boolean>] [-HasMemoryOptimizedObjects <Boolean>]
[-HonorBrokerPriority <Boolean>] [-IsAccessible <Boolean>] [-IsDatabaseSnapshot <Boolean>]
[-IsDatabaseSnapshotBase <Boolean>] [-IsDbAccessAdmin <Boolean>] [-IsDbBackupOperator <Boolean>]
[-IsDbDataReader <Boolean>] [-IsDbDataWriter <Boolean>] [-IsDbDdlAdmin <Boolean>]
[-IsDbDenyDataReader <Boolean>] [-IsDbDenyDataWriter <Boolean>] [-IsDbManager <Boolean>]
[-IsDbOwner <Boolean>] [-IsDbSecurityAdmin <Boolean>] [-IsFabricDatabase <Boolean>]
[-IsFullTextEnabled <Boolean>] [-IsLedger <Boolean>] [-IsLoginManager <Boolean>] [-IsMailHost <Boolean>]
[-IsManagementDataWarehouse <Boolean>] [-IsMaxSizeApplicable <Boolean>] [-IsMirroringEnabled <Boolean>]
[-IsParameterizationForced <Boolean>] [-IsReadCommittedSnapshotOn <Boolean>] [-IsSqlDw <Boolean>]
[-IsSqlDwEdition <Boolean>] [-IsSystemObject <Boolean>] [-IsVarDecimalStorageFormatEnabled <Boolean>]
[-IsVarDecimalStorageFormatSupported <Boolean>] [-LegacyCardinalityEstimation <Boolean>]
[-LegacyCardinalityEstimationForSecondary <Boolean>] [-LocalCursorsDefault <Boolean>]
[-NestedTriggersEnabled <Boolean>] [-NumericRoundAbortEnabled <Boolean>] [-ParameterSniffing <Boolean>]
[-ParameterSniffingForSecondary <Boolean>] [-QueryOptimizerHotfixes <Boolean>]
[-QueryOptimizerHotfixesForSecondary <Boolean>] [-QuotedIdentifiersEnabled <Boolean>] [-ReadOnly <Boolean>]
[-RecursiveTriggersEnabled <Boolean>] [-RemoteDataArchiveEnabled <Boolean>]
[-RemoteDataArchiveUseFederatedServiceAccount <Boolean>] [-TemporalHistoryRetentionEnabled <Boolean>]
[-TransformNoiseWords <Boolean>] [-Trustworthy <Boolean>] [-WarnOnRename <Boolean>]
[-ActiveConnections <Int32>] [-ChangeTrackingRetentionPeriod <Int32>] [-DefaultFullTextLanguage <Int32>]
[-DefaultLanguage <Int32>] [-ID <Int32>] [-MaxDop <Int32>] [-MaxDopForSecondary <Int32>]
[-MirroringRedoQueueMaxSize <Int32>] [-MirroringRoleSequence <Int32>] [-MirroringSafetySequence <Int32>]
[-MirroringTimeout <Int32>] [-TargetRecoveryTime <Int32>] [-TwoDigitYearCutoff <Int32>] [-Version <Int32>]
[-IndexSpaceUsage <Int64>] [-MaxSizeInBytes <Int64>] [-MemoryAllocatedToMemoryOptimizedObjectsInKB <Int64>]
[-MemoryUsedByMemoryOptimizedObjectsInKB <Int64>] [-MirroringFailoverLogSequenceNumber <Int64>]
[-PersistentVersionStoreSizeKB <Int64>] [-SpaceAvailable <Int64>] [-Size <Double>]
[-AvailabilityGroupName <String>] [-AzureServiceObjective <String>] [-CatalogCollation <String>]
[-Collation <String>] [-DboLogin <String>] [-DefaultFileGroup <String>] [-DefaultFileStreamFileGroup <String>]
[-DefaultFullTextCatalog <String>] [-DefaultSchema <String>] [-FilestreamDirectoryName <String>]
[-MirroringPartner <String>] [-MirroringPartnerInstance <String>] [-MirroringWitness <String>]
[-Owner <String>] [-PersistentVersionStoreFileGroup <String>] [-PrimaryFilePath <String>]
[-RemoteDataArchiveCredential <String>] [-RemoteDataArchiveEndpoint <String>]
[-RemoteDataArchiveLinkedServer <String>] [-RemoteDatabaseName <String>] [-UserName <String>]
[-AzureEdition <String>] [-CreateDate <DateTime>] [-LastBackupDate <DateTime>]
[-LastDifferentialBackupDate <DateTime>] [-LastGoodCheckDbTime <DateTime>] [-LastLogBackupDate <DateTime>]
[-DatabaseGuid <Guid>] [-MirroringID <Guid>] [-RecoveryForkGuid <Guid>] [-ServiceBrokerGuid <Guid>]
[-AvailabilityDatabaseSynchronizationState <AvailabilityDatabaseSynchronizationState>]
[-ChangeTrackingRetentionPeriodUnits <RetentionPeriodUnits>] [-CompatibilityLevel <CompatibilityLevel>]
[-ContainmentType <ContainmentType>] [-DatabaseEngineEdition <DatabaseEngineEdition>]
[-DatabaseEngineType <DatabaseEngineType>]
[-FilestreamNonTransactedAccess <FilestreamNonTransactedAccessType>]
[-LogReuseWaitStatus <LogReuseWaitStatus>] [-MirroringSafetyLevel <MirroringSafetyLevel>]
[-MirroringStatus <MirroringStatus>] [-MirroringWitnessStatus <MirroringWitnessStatus>]
[-PageVerify <PageVerify>] [-RecoveryModel <RecoveryModel>] [-ReplicationOptions <ReplicationOptions>]
[-SnapshotIsolationState <SnapshotIsolationState>] [-State <SqlSmoState>] [-Status <DatabaseStatus>]
[-UserAccess <DatabaseUserAccess>] [<CommonParameters>]
Test-SqlDscDatabaseProperty -DatabaseObject <Database> [-AcceleratedRecoveryEnabled <Boolean>]
[-ActiveDirectory <Boolean>] [-AnsiNullDefault <Boolean>] [-AnsiNullsEnabled <Boolean>]
[-AnsiPaddingEnabled <Boolean>] [-AnsiWarningsEnabled <Boolean>] [-ArithmeticAbortEnabled <Boolean>]
[-AutoClose <Boolean>] [-AutoCreateIncrementalStatisticsEnabled <Boolean>]
[-AutoCreateStatisticsEnabled <Boolean>] [-AutoShrink <Boolean>] [-AutoUpdateStatisticsAsync <Boolean>]
[-AutoUpdateStatisticsEnabled <Boolean>] [-BrokerEnabled <Boolean>] [-CaseSensitive <Boolean>]
[-ChangeTrackingAutoCleanUp <Boolean>] [-ChangeTrackingEnabled <Boolean>]
[-CloseCursorsOnCommitEnabled <Boolean>] [-ConcatenateNullYieldsNull <Boolean>]
[-DatabaseOwnershipChaining <Boolean>] [-DataRetentionEnabled <Boolean>]
[-DateCorrelationOptimization <Boolean>] [-DelayedDurability <Boolean>] [-EncryptionEnabled <Boolean>]
[-HasDatabaseEncryptionKey <Boolean>] [-HasFileInCloud <Boolean>] [-HasMemoryOptimizedObjects <Boolean>]
[-HonorBrokerPriority <Boolean>] [-IsAccessible <Boolean>] [-IsDatabaseSnapshot <Boolean>]
[-IsDatabaseSnapshotBase <Boolean>] [-IsDbAccessAdmin <Boolean>] [-IsDbBackupOperator <Boolean>]
[-IsDbDataReader <Boolean>] [-IsDbDataWriter <Boolean>] [-IsDbDdlAdmin <Boolean>]
[-IsDbDenyDataReader <Boolean>] [-IsDbDenyDataWriter <Boolean>] [-IsDbManager <Boolean>]
[-IsDbOwner <Boolean>] [-IsDbSecurityAdmin <Boolean>] [-IsFabricDatabase <Boolean>]
[-IsFullTextEnabled <Boolean>] [-IsLedger <Boolean>] [-IsLoginManager <Boolean>] [-IsMailHost <Boolean>]
[-IsManagementDataWarehouse <Boolean>] [-IsMaxSizeApplicable <Boolean>] [-IsMirroringEnabled <Boolean>]
[-IsParameterizationForced <Boolean>] [-IsReadCommittedSnapshotOn <Boolean>] [-IsSqlDw <Boolean>]
[-IsSqlDwEdition <Boolean>] [-IsSystemObject <Boolean>] [-IsVarDecimalStorageFormatEnabled <Boolean>]
[-IsVarDecimalStorageFormatSupported <Boolean>] [-LegacyCardinalityEstimation <Boolean>]
[-LegacyCardinalityEstimationForSecondary <Boolean>] [-LocalCursorsDefault <Boolean>]
[-NestedTriggersEnabled <Boolean>] [-NumericRoundAbortEnabled <Boolean>] [-ParameterSniffing <Boolean>]
[-ParameterSniffingForSecondary <Boolean>] [-QueryOptimizerHotfixes <Boolean>]
[-QueryOptimizerHotfixesForSecondary <Boolean>] [-QuotedIdentifiersEnabled <Boolean>] [-ReadOnly <Boolean>]
[-RecursiveTriggersEnabled <Boolean>] [-RemoteDataArchiveEnabled <Boolean>]
[-RemoteDataArchiveUseFederatedServiceAccount <Boolean>] [-TemporalHistoryRetentionEnabled <Boolean>]
[-TransformNoiseWords <Boolean>] [-Trustworthy <Boolean>] [-WarnOnRename <Boolean>]
[-ActiveConnections <Int32>] [-ChangeTrackingRetentionPeriod <Int32>] [-DefaultFullTextLanguage <Int32>]
[-DefaultLanguage <Int32>] [-ID <Int32>] [-MaxDop <Int32>] [-MaxDopForSecondary <Int32>]
[-MirroringRedoQueueMaxSize <Int32>] [-MirroringRoleSequence <Int32>] [-MirroringSafetySequence <Int32>]
[-MirroringTimeout <Int32>] [-TargetRecoveryTime <Int32>] [-TwoDigitYearCutoff <Int32>] [-Version <Int32>]
[-IndexSpaceUsage <Int64>] [-MaxSizeInBytes <Int64>] [-MemoryAllocatedToMemoryOptimizedObjectsInKB <Int64>]
[-MemoryUsedByMemoryOptimizedObjectsInKB <Int64>] [-MirroringFailoverLogSequenceNumber <Int64>]
[-PersistentVersionStoreSizeKB <Int64>] [-SpaceAvailable <Int64>] [-Size <Double>]
[-AvailabilityGroupName <String>] [-AzureServiceObjective <String>] [-CatalogCollation <String>]
[-Collation <String>] [-DboLogin <String>] [-DefaultFileGroup <String>] [-DefaultFileStreamFileGroup <String>]
[-DefaultFullTextCatalog <String>] [-DefaultSchema <String>] [-FilestreamDirectoryName <String>]
[-MirroringPartner <String>] [-MirroringPartnerInstance <String>] [-MirroringWitness <String>]
[-Owner <String>] [-PersistentVersionStoreFileGroup <String>] [-PrimaryFilePath <String>]
[-RemoteDataArchiveCredential <String>] [-RemoteDataArchiveEndpoint <String>]
[-RemoteDataArchiveLinkedServer <String>] [-RemoteDatabaseName <String>] [-UserName <String>]
[-AzureEdition <String>] [-CreateDate <DateTime>] [-LastBackupDate <DateTime>]
[-LastDifferentialBackupDate <DateTime>] [-LastGoodCheckDbTime <DateTime>] [-LastLogBackupDate <DateTime>]
[-DatabaseGuid <Guid>] [-MirroringID <Guid>] [-RecoveryForkGuid <Guid>] [-ServiceBrokerGuid <Guid>]
[-AvailabilityDatabaseSynchronizationState <AvailabilityDatabaseSynchronizationState>]
[-ChangeTrackingRetentionPeriodUnits <RetentionPeriodUnits>] [-CompatibilityLevel <CompatibilityLevel>]
[-ContainmentType <ContainmentType>] [-DatabaseEngineEdition <DatabaseEngineEdition>]
[-DatabaseEngineType <DatabaseEngineType>]
[-FilestreamNonTransactedAccess <FilestreamNonTransactedAccessType>]
[-LogReuseWaitStatus <LogReuseWaitStatus>] [-MirroringSafetyLevel <MirroringSafetyLevel>]
[-MirroringStatus <MirroringStatus>] [-MirroringWitnessStatus <MirroringWitnessStatus>]
[-PageVerify <PageVerify>] [-RecoveryModel <RecoveryModel>] [-ReplicationOptions <ReplicationOptions>]
[-SnapshotIsolationState <SnapshotIsolationState>] [-State <SqlSmoState>] [-Status <DatabaseStatus>]
[-UserAccess <DatabaseUserAccess>] [<CommonParameters>]
This command tests if database properties on a SQL Server Database Engine instance are in the desired state.
The command supports a comprehensive set of database properties including configuration settings, metadata, security properties, performance settings, and state information. Users can test one or multiple properties in a single command execution.
All properties correspond directly to Microsoft SQL Server Management Objects (SMO) Database class properties and support the same data types and values as the underlying SMO implementation.
$serverObject = Connect-SqlDscDatabaseEngine -InstanceName 'MyInstance'
Test-SqlDscDatabaseProperty -ServerObject $serverObject -Name 'MyDatabase' -Collation 'SQL_Latin1_General_CP1_CI_AS'
Tests if the database named MyDatabase has the specified collation.
$serverObject = Connect-SqlDscDatabaseEngine -InstanceName 'MyInstance'
$databaseObject = $serverObject | Get-SqlDscDatabase -Name 'MyDatabase'
Test-SqlDscDatabaseProperty -DatabaseObject $databaseObject -RecoveryModel 'Simple' -CompatibilityLevel 'Version160'
Tests if the database has the specified recovery model and compatibility level using a database object.
$serverObject = Connect-SqlDscDatabaseEngine -InstanceName 'MyInstance'
Test-SqlDscDatabaseProperty -ServerObject $serverObject -Name 'MyDatabase' -Owner 'sa' -AutoClose $false -Trustworthy $false
Tests multiple database properties at once.
Specifies whether Accelerated Database Recovery (ADR) is enabled for the database.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the number of active connections to the database (as observed by SMO).
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database participates in Active Directory integration features.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether new columns allow NULL by default unless explicitly specified (when ON).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether comparisons to NULL follow ANSI SQL behavior (when ON, x = NULL yields UNKNOWN).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether padding for variable-length columns (e.g., CHAR/VARCHAR) follows ANSI rules.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether ANSI warnings are generated for certain conditions (when ON, e.g., divide by zero).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether a query is terminated when an overflow or divide-by-zero error occurs.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database closes after the last user exits.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether creation of incremental statistics on partitioned tables is allowed.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether single-column statistics are automatically created for query optimization.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database automatically shrinks files when free space is detected.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether statistics are updated asynchronously, allowing queries to proceed with old stats.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether statistics are automatically updated when they are out-of-date.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the synchronization state of the database in an Availability Group.
Type: AvailabilityDatabaseSynchronizationState
Parameter Sets: (All)
Aliases:
Accepted values: NotSynchronizing, Synchronizing, Synchronized, Reverting, Initializing
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the name of the Availability Group to which the database belongs, if any.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the Azure SQL Database edition (e.g., Basic/Standard/Premium/GeneralPurpose/BusinessCritical).
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the Azure SQL Database service objective (e.g., S3, P1, GP_Gen5_4).
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether Service Broker is enabled for the database.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database collation is case-sensitive.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the catalog-level collation used for metadata and temporary objects.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether automatic cleanup of change tracking information is enabled.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether change tracking is enabled for the database.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the retention period value for change tracking information.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the units for the retention period (e.g., DAYS, HOURS).
Type: RetentionPeriodUnits
Parameter Sets: (All)
Aliases:
Accepted values: None, Minutes, Hours, Days
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether open cursors are closed when a transaction is committed.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the default collation for the database.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the database compatibility level (affects query processor behavior and features).
Type: CompatibilityLevel
Parameter Sets: (All)
Aliases:
Accepted values: Version60, Version65, Version70, Version80, Version90, Version100, Version110, Version120, Version130, Version140, Version150, Version160, Version170
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether concatenation with NULL results in NULL (when ON).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the containment level of the database (NONE or PARTIAL).
Type: ContainmentType
Parameter Sets: (All)
Aliases:
Accepted values: None, Partial
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the date and time that the database was created.
Type: DateTime
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the edition of the database engine hosting the database.
Type: DatabaseEngineEdition
Parameter Sets: (All)
Aliases:
Accepted values: Unknown, Personal, Standard, Enterprise, Express, SqlDatabase, SqlDataWarehouse, SqlStretchDatabase, SqlManagedInstance, SqlDatabaseEdge, SqlAzureArcManagedInstance, SqlOnDemand
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the engine type (e.g., Standalone, AzureSqlDatabase, SqlOnDemand).
Type: DatabaseEngineType
Parameter Sets: (All)
Aliases:
Accepted values: Unknown, Standalone, SqlAzureDatabase
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the unique identifier (GUID) of the database.
Type: Guid
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the database object to test properties for (from Get-SqlDscDatabase).
Type: Database
Parameter Sets: DatabaseObjectSet
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: FalseSpecifies whether ownership chaining across objects within the database is enabled.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether SQL Server data retention policy is enabled at the database level.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether date correlation optimization is enabled to speed up temporal joins.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the login that owns the database (dbo).
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the name of the default filegroup for the database.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the name of the default FILESTREAM filegroup.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the default full-text catalog used for full-text indexes.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the LCID of the default full-text language.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the ID of the default language for the database.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the default schema name for users without an explicit default schema.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether delayed transaction log flushes are enabled to improve throughput.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether Transparent Data Encryption (TDE) is enabled.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the directory name used for FILESTREAM data.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the FILESTREAM access level for non-transactional access.
Type: FilestreamNonTransactedAccessType
Parameter Sets: (All)
Aliases:
Accepted values: Off, ReadOnly, Full
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database has a database encryption key (TDE).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database has one or more files in Azure Storage.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database contains memory-optimized (In-Memory OLTP) objects.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether honoring Service Broker conversation priority is enabled.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the database ID (DB_ID). Unique numeric identifier assigned to the database by SQL Server.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the space used by indexes in KB.
Type: Int64
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database is accessible to the current connection.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database is a database snapshot.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database is the source (base) of one or more snapshots.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_accessadmin for this database.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_backupoperator.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_datareader.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_datawriter.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_ddladmin.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_denydatareader.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_denydatawriter.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_manager (Azure role).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_owner.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of db_securityadmin.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database is a Microsoft Fabric SQL database.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether full-text search is enabled.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database is enabled for SQL Ledger features.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the caller is member of the login manager role (Azure).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether Database Mail host features are configured on this database.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database is configured as the Management Data Warehouse.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether MaxSizeInBytes is enforced for the database.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether database mirroring is configured.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether parameterization of queries is forced by default (when ON).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether READ_COMMITTED_SNAPSHOT isolation is ON.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database is an Azure Synapse (SQL DW) database.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the edition corresponds to Azure Synapse (DW).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database is a system database (master, model, msdb, tempdb).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether vardecimal storage format is enabled.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether vardecimal storage format is supported by the server.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the timestamp of the last full database backup.
Type: DateTime
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the timestamp of the last differential backup.
Type: DateTime
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the timestamp when DBCC CHECKDB last completed successfully.
Type: DateTime
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the timestamp of the last transaction log backup.
Type: DateTime
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the legacy cardinality estimator is enabled for the primary.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the legacy cardinality estimator is enabled for secondary replicas.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether cursors are local by default instead of global (when ON).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the reason why the transaction log cannot be reused.
Type: LogReuseWaitStatus
Parameter Sets: (All)
Aliases:
Accepted values: Nothing, Checkpoint, LogBackup, BackupOrRestore, Transaction, Mirroring, Replication, SnapshotCreation, LogScan, Other
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the MAXDOP database-scoped configuration for primary replicas.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the MAXDOP database-scoped configuration for secondary replicas.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the maximum size of the database in bytes.
Type: Int64
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the memory allocated to memory-optimized objects (KB).
Type: Int64
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the memory used by memory-optimized objects (KB).
Type: Int64
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the mirroring failover LSN (if mirroring configured).
Type: Int64
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the unique mirroring ID for the database.
Type: Guid
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the mirroring partner server name (if configured).
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the mirroring partner instance name (if configured).
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the redo queue maximum size for mirroring/AGs.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the sequence number for mirroring role transitions.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the mirroring safety level (FULL/Off/HighPerformance).
Type: MirroringSafetyLevel
Parameter Sets: (All)
Aliases:
Accepted values: None, Unknown, Off, Full
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the sequence for mirroring safety changes.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the current mirroring state of the database.
Type: MirroringStatus
Parameter Sets: (All)
Aliases:
Accepted values: None, Suspended, Disconnected, Synchronizing, PendingFailover, Synchronized
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the timeout in seconds for mirroring sessions.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the mirroring witness server (if used).
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the status of the mirroring witness.
Type: MirroringWitnessStatus
Parameter Sets: (All)
Aliases:
Accepted values: None, Unknown, Connected, Disconnected
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the name of the database to test properties for. The logical database name as it appears in SQL Server.
Type: String
Parameter Sets: ServerObjectSet
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether triggers are allowed to fire other triggers (nested triggers).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether an error is raised on loss of precision due to rounding (when ON).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the owner (login) of the database.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the page verification setting (NONE, TORN_PAGE_DETECTION, CHECKSUM).
Type: PageVerify
Parameter Sets: (All)
Aliases:
Accepted values: None, TornPageDetection, Checksum
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether parameter sniffing behavior is enabled on the primary.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether parameter sniffing is enabled on secondary replicas.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the filegroup used for the Persistent Version Store (PVS).
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the size of the Persistent Version Store in KB.
Type: Int64
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the path of the primary data files directory.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether query optimizer hotfixes are enabled on the primary.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether query optimizer hotfixes are enabled on secondary replicas.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether identifiers can be delimited by double quotes (when ON).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether the database is in read-only mode.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the GUID for the current recovery fork of the database.
Type: Guid
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the database recovery model (FULL, BULK_LOGGED, SIMPLE).
Type: RecoveryModel
Parameter Sets: (All)
Aliases:
Accepted values: Full, BulkLogged, Simple
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether a trigger is allowed to fire itself recursively.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies that the ServerObject's databases should be refreshed before trying to get the database object. This is helpful when databases could have been modified outside of the ServerObject, for example through T-SQL. But on instances with a large amount of databases it might be better to make sure the ServerObject is recent enough.
This parameter is only used when testing properties using ServerObject and Name parameters.
Type: SwitchParameter
Parameter Sets: ServerObjectSet
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the credential name for Stretch Database/remote data archive.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether Stretch Database (remote data archive) is enabled.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the endpoint URL for remote data archive.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the linked server used by remote data archive.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether to use federated service account for remote data archive.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the remote database name for remote data archive.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the replication options that are enabled for the database.
Type: ReplicationOptions
Parameter Sets: (All)
Aliases:
Accepted values: None, Published, Subscribed, MergePublished, MergeSubscribed
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies current server connection object.
Type: Server
Parameter Sets: ServerObjectSet
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the unique Service Broker identifier for the database.
Type: Guid
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the approximate size of the database in MB (as reported by SMO).
Type: Double
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether SNAPSHOT isolation is OFF/ON/IN_TRANSITION.
Type: SnapshotIsolationState
Parameter Sets: (All)
Aliases:
Accepted values: Disabled, Enabled, PendingOff, PendingOn
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the free space available in the database (KB).
Type: Int64
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the general state of the SMO object.
Type: SqlSmoState
Parameter Sets: (All)
Aliases:
Accepted values: Pending, Creating, Existing, ToBeDropped, Dropped
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the operational status of the database as reported by SMO.
Type: DatabaseStatus
Parameter Sets: (All)
Aliases:
Accepted values: Normal, Restoring, RecoveryPending, Recovering, Suspect, Offline, Inaccessible, Standby, Shutdown, EmergencyMode, AutoClosed
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the target recovery time (seconds) for indirect checkpointing.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether automatic cleanup of system-versioned temporal history is enabled.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies how full-text noise word behavior is controlled during queries.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether implicit access to external resources by modules is allowed (use with caution).
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the two-digit year cutoff used for date conversion.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the database user access mode (MULTI_USER, RESTRICTED_USER, SINGLE_USER).
Type: DatabaseUserAccess
Parameter Sets: (All)
Aliases:
Accepted values: Multiple, Single, Restricted
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the user name for the current connection context (as seen by SMO).
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the internal version number of the database.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies whether a warning is emitted when objects are renamed.
Type: Boolean
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseThis cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.