For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database. Microsoft has not exposed this information in an easily digestible format. You can find a handful of options available online for returning this information. My favorite was this post by Rob Sewell.
It was my favorite.
And then I read this post by Pedro Lopes regarding SQL Server 2016 SP2 features. Buried deep in that post is this gem:
Expose last known good DBCC CHECKDB information – A new database option has been added to programmatically return the date of the last successful DBCC CHECKDB run. Users can now query DATABASEPROPERTYEX([database], ‘lastgoodcheckdbtime’) to obtain a single value representing the date/time of the last successful DBCC CHECKDB run on the specified database.
That’s right, we no longer need complicated scripts to find the last known good DBCC CHECKDB date. It’s as simple as a SELECT statement. This SELECT statement, to be exact:
SELECT DATABASEPROPERTYEX ('dbname' , 'LastGoodCheckDbTime' )
This is a wonderful addition. I have no idea why we didn’t have something so simple many, many years ago. But we have it now. So, let’s enjoy it a bit.
Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time
The statement above will return a DATETIME with the last known good date. If there is no CHECKDB recorded, it returns our old friend, 01-Jan-1900. I suppose it could have returned NULL, but NULL is “unknown”, and the answer here isn’t “unknown”. If there is no CHECKDB and you need to return a date, 01-Jan-1900 is your best friend. This is how Data Janitors earn their money.
Warrants mentioning: This feature is NOT available in SQL Server 2017 yet. So, if you try running this command on an instance of SQL 2017 you will get back a NULL result. You might think that means “no DBCC CHECKDB”, but you’d be wrong. The documentation for DATABASEPROPERTYEX is clear what a NULL result means.
So, if DATABASEPROPERTYEX (‘dbname’, ‘LastGoodCheckDbTime’) returns NULL, that means ‘Input not valid’. It is likely you are trying to run this command against an instance for which it is not supported. To make matters more confusing, the documentation suggests that this is supported for SQL2017. So, don’t be like me and spend an hour trying to make it work on SQL 2017. It’s not there yet. I can’t say this enough.
Finding Policy-Based Management Facets for DBCC CHECKDB
Since this new feature has made life so much easier for SQL Server administrators, I decided to check and see if there was a policy facet for DBCCCHECKDB.
You can’t query a DMV for the list of policy facets. The only way I’ve found to get this list is to use some Powershell. Here is the code I’ve used in the past to output the list to a file:
$conn = New-Object Microsoft.SQLServer.Management.Sdk.Sfc.SqlStoreConnection("server=PORC\SQL2016;Trusted_Connection=true");
$PolicyStore = New-Object Microsoft.SQLServer.Management.DMF.PolicyStore($conn);
$facets = [Microsoft.SqlServer.Management.Dmf.PolicyStore]::Facets
out-file "C:\TeamData\PBM_facet_counts_2016.txt"
foreach ($i in $facets)
{
$f = $facets[$i.Name]
$fp = $f.FacetProperties
foreach ($j in $fp)
{
$fpstring = $i.name + "," + $j.Name
$fpstring | out-file "C:\TeamData\PBM_facet_counts_2016.txt" -append
}
}
I’ve included the long list of facets at the bottom of this post if you are interested in viewing them. Two things worth mentioning here. The list of facets is identical from SQL2016 to SQL2017. So, no advancements in Policy-Based Management (PBM), and I don’t know if there are any advancements in PBM coming. I think PBM is a great feature that is not being used. And if it is not being used it is hard to justify engineering time.
The second thing worth mentioning is that there is no facet for DBCC CHECKDB. Again, this seems like a silly oversight from Microsoft going back to 2008. That’s an important piece of information and it should not have taken so long to make this detail easily discoverable. Then again…they have the telemetry to know how important this would be to customers…and I’m not going to argue with how they spend their time. I trust they are doing the best they can with the data they have.
Using Policy-Based Management to Find Last Good DBCC CHECKDB Time
So, there is no facet for us to use. That’s OK. We can create a custom condition using the ExecuteSql() function. The code we need is very simple now, thanks to the DATABASEPROPERTYEX feature.
We will create a new condition:
Here’s the code being used. Two things to mention here. First, you need two single quotes around the LastGoodCheckDbTime. That is not a typo. Second, I am using the DB_NAME() function, as the policy is being executed against a database target. This will allow the current database to be checked.
ExecuteSql('Numeric', '
SELECT DATEDIFF(dd
, (SELECT CONVERT(DATETIME, DATABASEPROPERTYEX (DB_NAME() , ''LastGoodCheckDbTime'' )))
, GETDATE())
')
Also, I am using DATEDIFF to return the difference in days since the last known DBCC CHECKDB command. How often you decide to run CHECKDB is up to you. For this example, I will set the condition to be less than or equal to 7 days.
You should use a number that works best for you. OK, now we are ready to create the policy.
Now we can evaluate against my instance:
As you can see, I’m not up to date on my maintenance for this instance. I only have one database that has a CHECKDB in the past 7 days.
Reporting
I’m not going to lie, the PBM GUI is not the best for viewing results. And unless you are using a Central Management Server, you are going to spend a lot of time going from one instance to another to review the results. Thankfully we have some options.
Here’s what I would do as a production SQL Server DBA, and I wanted to roll my own PBM solution.
First, I’d build the policy, make certain it worked, and then export it as an XML file.
Then, I’d use Powershell and the Invoke-PolicyEvaluation cmdlet, and execute the policy against all my instances.
I would output the results to XML and use a tool to parse those files into something readable. A tool like PowerBI, perhaps. Or something like Log and Event Manager, or Loggly, or Papertrail, or anything that lets me input a file and get value.
Lastly, I’d sit back with some scotch and some bacon. You should do what works for you though.
Summary
The DATABASEPROPERTYEX feature with LastGoodCheckDbTime is a great new feature inside of SQL Server. It is only in SQL Server 2016 SP2 right now. I am hopeful it will be in SQL Server 2017 soon.
You can use this new feature to create a policy using PBM to help you stay on top of your database maintenance tasks. It’s easy to implement. It’s also easy to implement a solution across your entire enterprise using Powershell.
List of Policy-Based Management Facets for SQL Server 2016 and SQL Server 2017
Here’s the list of facets returned from my instances of SQL Server 2016 and SQL Server 2017. Use this list to find a facet that may be useful for you to wrap into a policy. If you need help with a custom policy feel free to contact me.
ApplicationRole,CreateDate ApplicationRole,DateLastModified ApplicationRole,ID ApplicationRole,DefaultSchema ApplicationRole,Name AsymmetricKey,ID AsymmetricKey,KeyEncryptionAlgorithm AsymmetricKey,KeyLength AsymmetricKey,Owner AsymmetricKey,PrivateKeyEncryptionType AsymmetricKey,PublicKey AsymmetricKey,Sid AsymmetricKey,Thumbprint AsymmetricKey,ProviderName AsymmetricKey,Name Audit,CreateDate Audit,DateLastModified Audit,DestinationType Audit,Enabled Audit,FileName Audit,FilePath Audit,Guid Audit,ID Audit,MaximumFileSize Audit,MaximumFileSizeUnit Audit,MaximumRolloverFiles Audit,OnFailure Audit,QueueDelay Audit,ReserveDiskSpace Audit,Filter Audit,MaximumFiles Audit,Name AvailabilityDatabase,IsFailoverReady AvailabilityDatabase,IsJoined AvailabilityDatabase,IsPendingSecondarySuspend AvailabilityDatabase,IsSuspended AvailabilityDatabase,RecoveryLSN AvailabilityDatabase,SynchronizationState AvailabilityDatabase,TruncationLSN AvailabilityDatabase,UniqueId AvailabilityDatabase,Name AvailabilityGroup,AutomatedBackupPreference AvailabilityGroup,FailureConditionLevel AvailabilityGroup,HealthCheckTimeout AvailabilityGroup,ID AvailabilityGroup,LocalReplicaRole AvailabilityGroup,PrimaryReplicaServerName AvailabilityGroup,UniqueId AvailabilityGroup,BasicAvailabilityGroup AvailabilityGroup,DatabaseHealthTrigger AvailabilityGroup,DtcSupportEnabled AvailabilityGroup,IsDistributedAvailabilityGroup AvailabilityGroup,ClusterType AvailabilityGroup,RequiredCopiesToCommit AvailabilityGroup,Name IAvailabilityGroupState,IsOnline IAvailabilityGroupState,IsAutoFailover IAvailabilityGroupState,NumberOfSynchronizedSecondaryReplicas IAvailabilityGroupState,NumberOfNotSynchronizingReplicas IAvailabilityGroupState,NumberOfNotSynchronizedReplicas IAvailabilityGroupState,NumberOfReplicasWithUnhealthyRole IAvailabilityGroupState,NumberOfDisconnectedReplicas AvailabilityReplica,AvailabilityMode AvailabilityReplica,BackupPriority AvailabilityReplica,ConnectionModeInPrimaryRole AvailabilityReplica,ConnectionModeInSecondaryRole AvailabilityReplica,ConnectionState AvailabilityReplica,CreateDate AvailabilityReplica,DateLastModified AvailabilityReplica,EndpointUrl AvailabilityReplica,FailoverMode AvailabilityReplica,JoinState AvailabilityReplica,LastConnectErrorDescription AvailabilityReplica,LastConnectErrorNumber AvailabilityReplica,LastConnectErrorTimestamp AvailabilityReplica,MemberState AvailabilityReplica,OperationalState AvailabilityReplica,Owner AvailabilityReplica,QuorumVoteCount AvailabilityReplica,ReadonlyRoutingConnectionUrl AvailabilityReplica,Role AvailabilityReplica,RollupRecoveryState AvailabilityReplica,RollupSynchronizationState AvailabilityReplica,SessionTimeout AvailabilityReplica,UniqueId AvailabilityReplica,SeedingMode AvailabilityReplica,Name BackupDevice,BackupDeviceType BackupDevice,PhysicalLocation BackupDevice,SkipTapeLabel BackupDevice,Name BrokerPriority,ContractName BrokerPriority,ID BrokerPriority,LocalServiceName BrokerPriority,PriorityLevel BrokerPriority,RemoteServiceName BrokerPriority,Name BrokerService,ID BrokerService,IsSystemObject BrokerService,Owner BrokerService,QueueName BrokerService,QueueSchema BrokerService,Name Certificate,ActiveForServiceBrokerDialog Certificate,ExpirationDate Certificate,ID Certificate,Issuer Certificate,Owner Certificate,PrivateKeyEncryptionType Certificate,Serial Certificate,Sid Certificate,StartDate Certificate,Subject Certificate,Thumbprint Certificate,LastBackupDate Certificate,Name ColumnEncryptionKey,CreateDate ColumnEncryptionKey,DateLastModified ColumnEncryptionKey,ID ColumnEncryptionKey,Name ColumnEncryptionKeyValue,ColumnEncryptionKeyName ColumnEncryptionKeyValue,ColumnMasterKeyID ColumnEncryptionKeyValue,ColumnMasterKeyName ColumnEncryptionKeyValue,EncryptedValue ColumnEncryptionKeyValue,EncryptionAlgorithm ColumnMasterKey,CreateDate ColumnMasterKey,DateLastModified ColumnMasterKey,ID ColumnMasterKey,KeyPath ColumnMasterKey,KeyStoreProviderName ColumnMasterKey,Name Computer,Name Computer,ID Computer,IsClustered Computer,ProcessorUtilization Computer,CpuName Computer,CpuMaxClockSpeed Credential,CreateDate Credential,DateLastModified Credential,ID Credential,Identity Credential,MappedClassType Credential,ProviderName Credential,Name CryptographicProvider,AsymmetricKeyExportable CryptographicProvider,AsymmetricKeyImportable CryptographicProvider,AsymmetricKeyPersistable CryptographicProvider,AsymmetricKeySupported CryptographicProvider,AuthenticationType CryptographicProvider,DllPath CryptographicProvider,Enabled CryptographicProvider,ID CryptographicProvider,ProviderGuid CryptographicProvider,SymmetricKeyExportable CryptographicProvider,SymmetricKeyImportable CryptographicProvider,SymmetricKeyPersistable CryptographicProvider,SymmetricKeySupported CryptographicProvider,Name DataFile,AvailableSpace DataFile,FileName DataFile,Growth DataFile,GrowthType DataFile,ID DataFile,IsPrimaryFile DataFile,MaxSize DataFile,Size DataFile,UsedSpace DataFile,BytesReadFromDisk DataFile,BytesWrittenToDisk DataFile,IsOffline DataFile,IsReadOnly DataFile,IsReadOnlyMedia DataFile,IsSparse DataFile,NumberOfDiskReads DataFile,NumberOfDiskWrites DataFile,VolumeFreeSpace DataFile,Name IDataFilePerformanceFacet,SpaceUtilization Database,ActiveConnections Database,AutoClose Database,AutoShrink Database,CompatibilityLevel Database,CreateDate Database,DataSpaceUsage Database,DboLogin Database,DefaultFileGroup Database,DefaultSchema Database,ID Database,IndexSpaceUsage Database,IsAccessible Database,IsDbAccessAdmin Database,IsDbBackupOperator Database,IsDbDatareader Database,IsDbDatawriter Database,IsDbDdlAdmin Database,IsDbDenyDatareader Database,IsDbDenyDatawriter Database,IsDbOwner Database,IsDbSecurityAdmin Database,IsFullTextEnabled Database,IsSqlDw Database,IsSystemObject Database,Owner Database,PrimaryFilePath Database,ReplicationOptions Database,Size Database,SpaceAvailable Database,Status Database,UserName Database,AnsiNullDefault Database,AnsiNullsEnabled Database,AnsiPaddingEnabled Database,AnsiWarningsEnabled Database,ArithmeticAbortEnabled Database,AutoCreateStatisticsEnabled Database,AutoUpdateStatisticsEnabled Database,CaseSensitive Database,CloseCursorsOnCommitEnabled Database,Collation Database,ConcatenateNullYieldsNull Database,DatabaseOwnershipChaining Database,IsUpdateable Database,LastBackupDate Database,LastDifferentialBackupDate Database,LastLogBackupDate Database,LocalCursorsDefault Database,NumericRoundAbortEnabled Database,PageVerify Database,QuotedIdentifiersEnabled Database,ReadOnly Database,RecoveryModel Database,RecursiveTriggersEnabled Database,UserAccess Database,Version Database,AutoUpdateStatisticsAsync Database,BrokerEnabled Database,DatabaseGuid Database,DatabaseSnapshotBaseName Database,DateCorrelationOptimization Database,DefaultFullTextCatalog Database,IsDatabaseSnapshot Database,IsDatabaseSnapshotBase Database,IsMailHost Database,IsMirroringEnabled Database,IsParameterizationForced Database,IsReadCommittedSnapshotOn Database,IsVarDecimalStorageFormatEnabled Database,LogReuseWaitStatus Database,MirroringFailoverLogSequenceNumber Database,MirroringID Database,MirroringPartner Database,MirroringPartnerInstance Database,MirroringRedoQueueMaxSize Database,MirroringRoleSequence Database,MirroringSafetyLevel Database,MirroringSafetySequence Database,MirroringStatus Database,MirroringTimeout Database,MirroringWitness Database,MirroringWitnessStatus Database,RecoveryForkGuid Database,ServiceBrokerGuid Database,SnapshotIsolationState Database,Trustworthy Database,ChangeTrackingAutoCleanUp Database,ChangeTrackingEnabled Database,ChangeTrackingRetentionPeriod Database,ChangeTrackingRetentionPeriodUnits Database,DefaultFileStreamFileGroup Database,EncryptionEnabled Database,HonorBrokerPriority Database,IsManagementDataWarehouse Database,AvailabilityDatabaseSynchronizationState Database,AvailabilityGroupName Database,ContainmentType Database,FilestreamDirectoryName Database,FilestreamNonTransactedAccess Database,NestedTriggersEnabled Database,TargetRecoveryTime Database,TransformNoiseWords Database,TwoDigitYearCutoff Database,AutoCreateIncrementalStatisticsEnabled Database,DelayedDurability Database,HasFileInCloud Database,HasMemoryOptimizedObjects Database,MemoryAllocatedToMemoryOptimizedObjectsInKB Database,MemoryUsedByMemoryOptimizedObjectsInKB Database,LegacyCardinalityEstimation Database,LegacyCardinalityEstimationForSecondary Database,MaxDop Database,ParameterSniffing Database,ParameterSniffingForSecondary Database,QueryOptimizerHotfixes Database,QueryOptimizerHotfixesForSecondary Database,RemoteDataArchiveCredential Database,RemoteDataArchiveEnabled Database,RemoteDataArchiveEndpoint Database,RemoteDataArchiveLinkedServer Database,RemoteDataArchiveUseFederatedServiceAccount Database,RemoteDatabaseName Database,Name DatabaseAuditSpecification,AuditName DatabaseAuditSpecification,CreateDate DatabaseAuditSpecification,DateLastModified DatabaseAuditSpecification,Enabled DatabaseAuditSpecification,Guid DatabaseAuditSpecification,ID DatabaseAuditSpecification,Name DatabaseDdlTrigger,AnsiNullsStatus DatabaseDdlTrigger,AssemblyName DatabaseDdlTrigger,BodyStartIndex DatabaseDdlTrigger,ClassName DatabaseDdlTrigger,CreateDate DatabaseDdlTrigger,DateLastModified DatabaseDdlTrigger,ExecutionContext DatabaseDdlTrigger,ExecutionContextUser DatabaseDdlTrigger,ID DatabaseDdlTrigger,ImplementationType DatabaseDdlTrigger,IsEnabled DatabaseDdlTrigger,IsEncrypted DatabaseDdlTrigger,IsSystemObject DatabaseDdlTrigger,MethodName DatabaseDdlTrigger,NotForReplication DatabaseDdlTrigger,QuotedIdentifierStatus DatabaseDdlTrigger,Text DatabaseDdlTrigger,Name IDatabaseMaintenanceFacet,RecoveryModel IDatabaseMaintenanceFacet,ReadOnly IDatabaseMaintenanceFacet,PageVerify IDatabaseMaintenanceFacet,Status IDatabaseMaintenanceFacet,LastBackupDate IDatabaseMaintenanceFacet,LastLogBackupDate IDatabaseMaintenanceFacet,DataAndBackupOnSeparateLogicalVolumes IDatabaseMaintenanceFacet,TargetRecoveryTime IDatabaseMaintenanceFacet,DelayedDurability IDatabaseOptions,AnsiNullDefault IDatabaseOptions,AnsiNullsEnabled IDatabaseOptions,AnsiPaddingEnabled IDatabaseOptions,AnsiWarningsEnabled IDatabaseOptions,ArithmeticAbortEnabled IDatabaseOptions,AutoClose IDatabaseOptions,AutoCreateStatisticsEnabled IDatabaseOptions,AutoCreateIncrementalStatisticsEnabled IDatabaseOptions,AutoShrink IDatabaseOptions,AutoUpdateStatisticsAsync IDatabaseOptions,AutoUpdateStatisticsEnabled IDatabaseOptions,BrokerEnabled IDatabaseOptions,ChangeTrackingAutoCleanUp IDatabaseOptions,ChangeTrackingEnabled IDatabaseOptions,ChangeTrackingRetentionPeriod IDatabaseOptions,ChangeTrackingRetentionPeriodUnits IDatabaseOptions,CloseCursorsOnCommitEnabled IDatabaseOptions,Collation IDatabaseOptions,CompatibilityLevel IDatabaseOptions,ConcatenateNullYieldsNull IDatabaseOptions,CreateDate IDatabaseOptions,DatabaseOwnershipChaining IDatabaseOptions,DatabaseSnapshotBaseName IDatabaseOptions,DateCorrelationOptimization IDatabaseOptions,DefaultFileGroup IDatabaseOptions,DefaultFileStreamFileGroup IDatabaseOptions,EncryptionEnabled IDatabaseOptions,HonorBrokerPriority IDatabaseOptions,ID IDatabaseOptions,IsParameterizationForced IDatabaseOptions,IsReadCommittedSnapshotOn IDatabaseOptions,IsSystemObject IDatabaseOptions,IsUpdateable IDatabaseOptions,LocalCursorsDefault IDatabaseOptions,Name IDatabaseOptions,Owner IDatabaseOptions,NumericRoundAbortEnabled IDatabaseOptions,MirroringTimeout IDatabaseOptions,PageVerify IDatabaseOptions,PrimaryFilePath IDatabaseOptions,QuotedIdentifiersEnabled IDatabaseOptions,ReadOnly IDatabaseOptions,RecoveryModel IDatabaseOptions,RecursiveTriggersEnabled IDatabaseOptions,RemoteDataArchiveEnabled IDatabaseOptions,RemoteDataArchiveEndpoint IDatabaseOptions,RemoteDataArchiveLinkedServer IDatabaseOptions,RemoteDatabaseName IDatabaseOptions,RemoteDataArchiveUseFederatedServiceAccount IDatabaseOptions,RemoteDataArchiveCredential IDatabaseOptions,Trustworthy IDatabaseOptions,UserAccess IDatabaseOptions,TargetRecoveryTime IDatabaseOptions,DelayedDurability IDatabasePerformanceFacet,AutoClose IDatabasePerformanceFacet,AutoShrink IDatabasePerformanceFacet,Size IDatabasePerformanceFacet,DataAndLogFilesOnSeparateLogicalVolumes IDatabasePerformanceFacet,CollationMatchesModelOrMaster IDatabasePerformanceFacet,IsSystemObject IDatabasePerformanceFacet,Status DatabaseReplicaState,AvailabilityDatabaseName DatabaseReplicaState,AvailabilityDateabaseId DatabaseReplicaState,AvailabilityGroupId DatabaseReplicaState,AvailabilityGroupName DatabaseReplicaState,AvailabilityReplicaId DatabaseReplicaState,AvailabilityReplicaServerName DatabaseReplicaState,DatabaseId DatabaseReplicaState,EndOfLogLSN DatabaseReplicaState,EstimatedDataLoss DatabaseReplicaState,EstimatedRecoveryTime DatabaseReplicaState,FileStreamSendRate DatabaseReplicaState,IsFailoverReady DatabaseReplicaState,IsJoined DatabaseReplicaState,IsLocal DatabaseReplicaState,IsSuspended DatabaseReplicaState,LastCommitLSN DatabaseReplicaState,LastCommitTime DatabaseReplicaState,LastHardenedLSN DatabaseReplicaState,LastHardenedTime DatabaseReplicaState,LastReceivedLSN DatabaseReplicaState,LastReceivedTime DatabaseReplicaState,LastRedoneLSN DatabaseReplicaState,LastRedoneTime DatabaseReplicaState,LastSentLSN DatabaseReplicaState,LastSentTime DatabaseReplicaState,LogSendQueueSize DatabaseReplicaState,LogSendRate DatabaseReplicaState,RecoveryLSN DatabaseReplicaState,RedoQueueSize DatabaseReplicaState,RedoRate DatabaseReplicaState,ReplicaAvailabilityMode DatabaseReplicaState,ReplicaRole DatabaseReplicaState,SuspendReason DatabaseReplicaState,SynchronizationPerformance DatabaseReplicaState,SynchronizationState DatabaseReplicaState,TruncationLSN DatabaseRole,CreateDate DatabaseRole,DateLastModified DatabaseRole,ID DatabaseRole,IsFixedRole DatabaseRole,Owner DatabaseRole,Name IDatabaseSecurityFacet,Trustworthy IDatabaseSecurityFacet,IsOwnerSysadmin Default,CreateDate Default,ID Default,Schema Default,Name DeployedDac,Id DeployedDac,Name DeployedDac,ServerInstanceName DeployedDac,DeployedDate DeployedDac,Description DeployedDac,ProcessorUtilization DeployedDac,DatabaseName DeployedDac,ComputerName DeployedDac,Collation DeployedDac,CompatibilityLevel DeployedDac,EncryptionEnabled DeployedDac,RecoveryModel DeployedDac,Trustworthy DeployedDac,DacProcessorHealthState DeployedDac,ComputerProcessorHealthState DeployedDac,FileSpaceHealthState DeployedDac,VolumeSpaceHealthState DeployedDac,ContainsOverUtilizedVolumes DeployedDac,ContainsUnderUtilizedVolumes DeployedDac,ContainsOverUtilizedFileGroups DeployedDac,ContainsUnderUtilizedFileGroups DeployedDac,IsPolicyOverridden DeployedDac,DatabaseState Endpoint,EndpointState Endpoint,EndpointType Endpoint,ID Endpoint,IsAdminEndpoint Endpoint,IsSystemObject Endpoint,Owner Endpoint,ProtocolType Endpoint,Name FileGroup,ID FileGroup,IsDefault FileGroup,ReadOnly FileGroup,Size FileGroup,FileGroupType FileGroup,IsFileStream FileGroup,Name FullTextCatalog,ErrorLogSize FullTextCatalog,FullTextIndexSize FullTextCatalog,HasFullTextIndexedTables FullTextCatalog,ID FullTextCatalog,ItemCount FullTextCatalog,PopulationCompletionDate FullTextCatalog,PopulationStatus FullTextCatalog,RootPath FullTextCatalog,UniqueKeyCount FullTextCatalog,FileGroup FullTextCatalog,IsAccentSensitive FullTextCatalog,IsDefault FullTextCatalog,Owner FullTextCatalog,Name FullTextIndex,CatalogName FullTextIndex,ChangeTracking FullTextIndex,IsEnabled FullTextIndex,PopulationStatus FullTextIndex,UniqueIndexName FullTextIndex,DocumentsProcessed FullTextIndex,ItemCount FullTextIndex,NumberOfFailures FullTextIndex,PendingChanges FullTextIndex,FilegroupName FullTextIndex,StopListName FullTextIndex,StopListOption FullTextIndex,SearchPropertyListName FullTextStopList,ID FullTextStopList,Owner FullTextStopList,Name Index,DisallowPageLocks Index,DisallowRowLocks Index,FileGroup Index,FillFactor Index,HasSparseColumn Index,ID Index,IgnoreDuplicateKeys Index,IndexKeyType Index,IndexType Index,IsClustered Index,IsFullTextKey Index,IsSystemNamed Index,IsSystemObject Index,IsUnique Index,NoAutomaticRecomputation Index,PadIndex Index,SpaceUsed Index,IsDisabled Index,IsPartitioned Index,IsXmlIndex Index,ParentXmlIndex Index,PartitionScheme Index,SecondaryXmlIndexType Index,BoundingBoxXMax Index,BoundingBoxXMin Index,BoundingBoxYMax Index,BoundingBoxYMin Index,CellsPerObject Index,FileStreamFileGroup Index,FileStreamPartitionScheme Index,FilterDefinition Index,HasCompressedPartitions Index,HasFilter Index,IsSpatialIndex Index,Level1Grid Index,Level2Grid Index,Level3Grid Index,Level4Grid Index,SpatialIndexType Index,IndexedXmlPathName Index,IsFileTableDefined Index,BucketCount Index,IsMemoryOptimized Index,CompressionDelay Index,ResumableOperationState Index,Name LinkedServer,Catalog LinkedServer,CollationCompatible LinkedServer,DataAccess LinkedServer,DataSource LinkedServer,DistPublisher LinkedServer,Distributor LinkedServer,ID LinkedServer,Location LinkedServer,ProductName LinkedServer,ProviderName LinkedServer,Publisher LinkedServer,Rpc LinkedServer,RpcOut LinkedServer,Subscriber LinkedServer,CollationName LinkedServer,ConnectTimeout LinkedServer,LazySchemaValidation LinkedServer,QueryTimeout LinkedServer,UseRemoteCollation LinkedServer,DateLastModified LinkedServer,IsPromotionofDistributedTransactionsForRPCEnabled LinkedServer,Name LogFile,FileName LogFile,Growth LogFile,GrowthType LogFile,ID LogFile,MaxSize LogFile,Size LogFile,UsedSpace LogFile,BytesReadFromDisk LogFile,BytesWrittenToDisk LogFile,IsOffline LogFile,IsReadOnly LogFile,IsReadOnlyMedia LogFile,IsSparse LogFile,NumberOfDiskReads LogFile,NumberOfDiskWrites LogFile,VolumeFreeSpace LogFile,Name ILogFilePerformanceFacet,SpaceUtilization Login,CreateDate Login,DateLastModified Login,DefaultDatabase Login,DenyWindowsLogin Login,HasAccess Login,IsSystemObject Login,Language Login,LanguageAlias Login,LoginType Login,Sid Login,WindowsLoginAccessType Login,AsymmetricKey Login,Certificate Login,Credential Login,ID Login,IsDisabled Login,IsLocked Login,IsPasswordExpired Login,MustChangePassword Login,PasswordExpirationEnabled Login,PasswordPolicyEnforced Login,PasswordHashAlgorithm Login,Name ILoginOptions,AsymmetricKey ILoginOptions,Certificate ILoginOptions,CreateDate ILoginOptions,Credential ILoginOptions,DefaultDatabase ILoginOptions,ID ILoginOptions,IsDisabled ILoginOptions,IsLocked ILoginOptions,IsSystemObject ILoginOptions,Language ILoginOptions,LanguageAlias ILoginOptions,MustChangePassword ILoginOptions,Name ILoginOptions,PasswordExpirationEnabled ILoginOptions,PasswordPolicyEnforced MessageType,ID MessageType,IsSystemObject MessageType,MessageTypeValidation MessageType,Owner MessageType,ValidationXmlSchemaCollection MessageType,ValidationXmlSchemaCollectionSchema MessageType,Name IMultipartNameFacet,Name IMultipartNameFacet,Schema INameFacet,Name PartitionFunction,CreateDate PartitionFunction,ID PartitionFunction,NumberOfPartitions PartitionFunction,RangeType PartitionFunction,Name PartitionScheme,ID PartitionScheme,NextUsedFileGroup PartitionScheme,PartitionFunction PartitionScheme,Name PlanGuide,Hints PlanGuide,ID PlanGuide,IsDisabled PlanGuide,Parameters PlanGuide,ScopeBatch PlanGuide,ScopeObjectName PlanGuide,ScopeSchemaName PlanGuide,ScopeType PlanGuide,Statement PlanGuide,Name RemoteServiceBinding,CertificateUser RemoteServiceBinding,ID RemoteServiceBinding,IsAnonymous RemoteServiceBinding,Owner RemoteServiceBinding,RemoteService RemoteServiceBinding,Name ResourceGovernor,ClassifierFunction ResourceGovernor,Enabled ResourceGovernor,ReconfigurePending ResourceGovernor,MaxOutstandingIOPerVolume ResourcePool,ID ResourcePool,IsSystemObject ResourcePool,MaximumCpuPercentage ResourcePool,MaximumMemoryPercentage ResourcePool,MinimumCpuPercentage ResourcePool,MinimumMemoryPercentage ResourcePool,CapCpuPercentage ResourcePool,MaximumIopsPerVolume ResourcePool,MinimumIopsPerVolume ResourcePool,Name Rule,CreateDate Rule,ID Rule,DateLastModified Rule,Schema Rule,Name Schema,ID Schema,IsSystemObject Schema,Owner Schema,Name SearchPropertyList,DateCreated SearchPropertyList,DateLastModified SearchPropertyList,ID SearchPropertyList,Owner SearchPropertyList,Name Sequence,CacheSize Sequence,CreateDate Sequence,DateLastModified Sequence,ID Sequence,IsCycleEnabled Sequence,IsExhausted Sequence,IsSchemaOwned Sequence,Owner Sequence,SequenceCacheType Sequence,Schema Sequence,Name Server,AuditLevel Server,BackupDirectory Server,BuildNumber Server,DefaultFile Server,DefaultLog Server,ErrorLogPath Server,HostPlatform Server,InstallDataDirectory Server,IsCaseSensitive Server,IsFullTextInstalled Server,IsXTPSupported Server,Language Server,MailProfile Server,MasterDBLogPath Server,MasterDBPath Server,MaxPrecision Server,NumberOfLogFiles Server,OSVersion Server,PerfMonMode Server,PhysicalMemory Server,Platform Server,Processors Server,Product Server,RootDirectory Server,ServerType Server,ServiceName Server,VersionMajor Server,VersionMinor Server,Collation Server,Edition Server,EngineEdition Server,InstanceName Server,IsClustered Server,IsSingleUser Server,NetName Server,ProductLevel Server,Status Server,TapeLoadWaitTime Server,VersionString Server,BrowserServiceAccount Server,BrowserStartMode Server,BuildClrVersionString Server,CollationID Server,ComparisonStyle Server,ComputerNamePhysicalNetBIOS Server,InstallSharedDirectory Server,NamedPipesEnabled Server,ResourceLastUpdateDateTime Server,ResourceVersionString Server,ServiceAccount Server,ServiceInstanceId Server,ServiceStartMode Server,SqlCharSet Server,SqlCharSetName Server,SqlSortOrder Server,SqlSortOrderName Server,TcpEnabled Server,FilestreamLevel Server,FilestreamShareName Server,PhysicalMemoryUsageInKB Server,SqlDomainGroup Server,ProcessorUsage Server,ClusterName Server,ClusterQuorumState Server,ClusterQuorumType Server,HadrManagerStatus Server,IsHadrEnabled Server,IsPolyBaseInstalled Server,HostDistribution Server,HostRelease Server,HostServicePackLevel Server,HostSku IServerAuditFacet,DefaultTraceEnabled IServerAuditFacet,C2AuditTracingEnabled IServerAuditFacet,LoginAuditLevel ServerAuditSpecification,AuditName ServerAuditSpecification,CreateDate ServerAuditSpecification,DateLastModified ServerAuditSpecification,Enabled ServerAuditSpecification,Guid ServerAuditSpecification,ID ServerAuditSpecification,Name IServerConfigurationFacet,ContainmentEnabled IServerConfigurationFacet,AdHocRemoteQueriesEnabled IServerConfigurationFacet,AffinityMask IServerConfigurationFacet,Affinity64Mask IServerConfigurationFacet,AffinityIOMask IServerConfigurationFacet,Affinity64IOMask IServerConfigurationFacet,AgentXPsEnabled IServerConfigurationFacet,AllowUpdates IServerConfigurationFacet,AweEnabled IServerConfigurationFacet,BlockedProcessThreshold IServerConfigurationFacet,C2AuditTracingEnabled IServerConfigurationFacet,ClrIntegrationEnabled IServerConfigurationFacet,CommonCriteriaComplianceEnabled IServerConfigurationFacet,CostThresholdForParallelism IServerConfigurationFacet,CrossDBOwnershipChainingEnabled IServerConfigurationFacet,CursorThreshold IServerConfigurationFacet,DatabaseMailEnabled IServerConfigurationFacet,DefaultTraceEnabled IServerConfigurationFacet,DefaultFullTextLanguage IServerConfigurationFacet,DefaultLanguage IServerConfigurationFacet,DisallowResultsFromTriggers IServerConfigurationFacet,FillFactor IServerConfigurationFacet,FullTextCrawlBandwidthMin IServerConfigurationFacet,FullTextCrawlBandwidthMax IServerConfigurationFacet,FullTextNotifyBandwidthMin IServerConfigurationFacet,FullTextNotifyBandwidthMax IServerConfigurationFacet,FullTextCrawlRangeMax IServerConfigurationFacet,InDoubtTransactionResolution IServerConfigurationFacet,IndexCreateMemory IServerConfigurationFacet,LightweightPoolingEnabled IServerConfigurationFacet,DynamicLocks IServerConfigurationFacet,MaxDegreeOfParallelism IServerConfigurationFacet,MaxServerMemory IServerConfigurationFacet,MaxWorkerThreads IServerConfigurationFacet,MediaRetention IServerConfigurationFacet,MinMemoryPerQuery IServerConfigurationFacet,MinServerMemory IServerConfigurationFacet,NestedTriggersEnabled IServerConfigurationFacet,NetworkPacketSize IServerConfigurationFacet,OleAutomationEnabled IServerConfigurationFacet,OpenObjects IServerConfigurationFacet,PrecomputeRank IServerConfigurationFacet,PriorityBoost IServerConfigurationFacet,ProtocolHandlerTimeout IServerConfigurationFacet,QueryGovernorCostLimit IServerConfigurationFacet,QueryWait IServerConfigurationFacet,RecoveryInterval IServerConfigurationFacet,RemoteAccessEnabled IServerConfigurationFacet,RemoteDacEnabled IServerConfigurationFacet,RemoteLoginTimeout IServerConfigurationFacet,RemoteProcTransEnabled IServerConfigurationFacet,RemoteQueryTimeout IServerConfigurationFacet,ReplicationMaxTextSize IServerConfigurationFacet,ReplicationXPsEnabled IServerConfigurationFacet,ScanForStartupProcedures IServerConfigurationFacet,ServerTriggerRecursionEnabled IServerConfigurationFacet,SetWorkingSetSize IServerConfigurationFacet,ShowAdvancedOptions IServerConfigurationFacet,SmoAndDmoXPsEnabled IServerConfigurationFacet,SqlMailEnabled IServerConfigurationFacet,TransformNoiseWords IServerConfigurationFacet,TwoDigitYearCutoff IServerConfigurationFacet,UserConnections IServerConfigurationFacet,UserInstanceTimeout IServerConfigurationFacet,UserInstancesEnabled IServerConfigurationFacet,UserOptions IServerConfigurationFacet,WebAssistantEnabled IServerConfigurationFacet,XPCmdShellEnabled IServerConfigurationFacet,DefaultBackupCompressionEnabled IServerConfigurationFacet,ExtensibleKeyManagementEnabled IServerConfigurationFacet,FilestreamAccessLevel IServerConfigurationFacet,OptimizeAdhocWorkloads IServerConfigurationFacet,RemoteDataArchiveEnabled ServerDdlTrigger,AnsiNullsStatus ServerDdlTrigger,AssemblyName ServerDdlTrigger,BodyStartIndex ServerDdlTrigger,ClassName ServerDdlTrigger,CreateDate ServerDdlTrigger,DateLastModified ServerDdlTrigger,ExecutionContext ServerDdlTrigger,ExecutionContextLogin ServerDdlTrigger,ID ServerDdlTrigger,ImplementationType ServerDdlTrigger,IsEnabled ServerDdlTrigger,IsEncrypted ServerDdlTrigger,IsSystemObject ServerDdlTrigger,MethodName ServerDdlTrigger,QuotedIdentifierStatus ServerDdlTrigger,Text ServerDdlTrigger,Name IServerInformation,Collation IServerInformation,Edition IServerInformation,ErrorLogPath IServerInformation,IsCaseSensitive IServerInformation,IsClustered IServerInformation,IsFullTextInstalled IServerInformation,IsPolyBaseInstalled IServerInformation,IsSingleUser IServerInformation,Language IServerInformation,MasterDBLogPath IServerInformation,MasterDBPath IServerInformation,MaxPrecision IServerInformation,NetName IServerInformation,OSVersion IServerInformation,PhysicalMemory IServerInformation,Platform IServerInformation,Processors IServerInformation,Product IServerInformation,ProductLevel IServerInformation,RootDirectory IServerInformation,VersionString IServerInformation,EngineEdition IServerInformation,VersionMajor IServerInformation,VersionMinor IServerInformation,BuildClrVersionString IServerInformation,BuildNumber IServerInformation,CollationID IServerInformation,ComparisonStyle IServerInformation,ComputerNamePhysicalNetBIOS IServerInformation,ResourceLastUpdateDateTime IServerInformation,ResourceVersionString IServerInformation,SqlCharSet IServerInformation,SqlCharSetName IServerInformation,SqlSortOrder IServerInformation,SqlSortOrderName IServerInformation,IsHadrEnabled IServerInformation,IsXTPSupported IServerSetupFacet,ServiceName IServerSetupFacet,EngineServiceAccount IServerSetupFacet,ServiceStartMode IServerSetupFacet,InstanceName IServerSetupFacet,ServiceInstanceIdSuffix IServerSetupFacet,FilestreamLevel IServerSetupFacet,FilestreamShareName IServerSetupFacet,UserInstancesEnabled IServerSetupFacet,Collation IServerSetupFacet,SqlDomainGroup IServerSetupFacet,WindowsUsersAndGroupsInSysadminRole IServerSetupFacet,LoginMode IServerSetupFacet,InstallDataDirectory IServerSetupFacet,BackupDirectory IServerSetupFacet,DefaultFile IServerSetupFacet,DefaultLog IServerSetupFacet,TempdbPrimaryFilePath IServerSetupFacet,TempdbLogPath IServerSetupFacet,AgentStartMode IServerSetupFacet,AgentServiceAccount IServerSetupFacet,AgentDomainGroup IServerSetupFacet,NamedPipesEnabled IServerSetupFacet,TcpEnabled IServerSetupFacet,InstallSharedDirectory IServerSetupFacet,BrowserStartMode IServerSetupFacet,BrowserServiceAccount IServerPerformanceFacet,AffinityMask IServerPerformanceFacet,Affinity64Mask IServerPerformanceFacet,AffinityIOMask IServerPerformanceFacet,Affinity64IOMask IServerPerformanceFacet,BlockedProcessThreshold IServerPerformanceFacet,DynamicLocks IServerPerformanceFacet,LightweightPoolingEnabled IServerPerformanceFacet,MaxDegreeOfParallelism IServerPerformanceFacet,CostThresholdForParallelism IServerPerformanceFacet,MaxWorkerThreads IServerPerformanceFacet,NetworkPacketSize IServerPerformanceFacet,OpenObjects IServerProtocolSettingsFacet,ExtendedProtection IServerProtocolSettingsFacet,ForceEncryption IServerProtocolSettingsFacet,AcceptedNTLMSPNs ServerRole,ID ServerRole,DateCreated ServerRole,DateModified ServerRole,IsFixedRole ServerRole,Owner ServerRole,Name IServerSecurityFacet,PublicServerRoleIsGrantedPermissions IServerSecurityFacet,LoginMode IServerSecurityFacet,XPCmdShellEnabled IServerSecurityFacet,CrossDBOwnershipChainingEnabled IServerSecurityFacet,CommonCriteriaComplianceEnabled IServerSecurityFacet,CmdExecRightsForSystemAdminsOnly IServerSecurityFacet,ProxyAccountIsGrantedToPublicRole IServerSecurityFacet,ReplaceAlertTokensEnabled IServerSecurityFacet,ProxyAccountEnabled IServerSelectionFacet,BuildNumber IServerSelectionFacet,Collation IServerSelectionFacet,Edition IServerSelectionFacet,IsCaseSensitive IServerSelectionFacet,Language IServerSelectionFacet,NamedPipesEnabled IServerSelectionFacet,OSVersion IServerSelectionFacet,Platform IServerSelectionFacet,TcpEnabled IServerSelectionFacet,VersionMajor IServerSelectionFacet,VersionMinor IServerSettings,AuditLevel IServerSettings,BackupDirectory IServerSettings,DefaultFile IServerSettings,DefaultLog IServerSettings,LoginMode IServerSettings,MailProfile IServerSettings,NumberOfLogFiles IServerSettings,PerfMonMode IServerSettings,TapeLoadWaitTime ServiceContract,ID ServiceContract,IsSystemObject ServiceContract,Owner ServiceContract,Name ServiceQueue,ActivationExecutionContext ServiceQueue,CreateDate ServiceQueue,DateLastModified ServiceQueue,ExecutionContextPrincipal ServiceQueue,FileGroup ServiceQueue,ID ServiceQueue,IsActivationEnabled ServiceQueue,IsEnqueueEnabled ServiceQueue,IsRetentionEnabled ServiceQueue,IsSystemObject ServiceQueue,MaxReaders ServiceQueue,ProcedureDatabase ServiceQueue,ProcedureName ServiceQueue,ProcedureSchema ServiceQueue,RowCount ServiceQueue,IsPoisonMessageHandlingEnabled ServiceQueue,Schema ServiceQueue,Name ServiceRoute,Address ServiceRoute,BrokerInstance ServiceRoute,ExpirationDate ServiceRoute,ID ServiceRoute,MirrorAddress ServiceRoute,Owner ServiceRoute,RemoteService ServiceRoute,Name SmartAdmin,BackupEnabled SmartAdmin,BackupRetentionPeriodInDays SmartAdmin,CredentialName SmartAdmin,EncryptionAlgorithm SmartAdmin,EncryptorName SmartAdmin,EncryptorType SmartAdmin,MasterSwitch SmartAdmin,StorageUrl ISmartAdminState,IsMasterSwitchEnabled ISmartAdminState,IsBackupEnabled ISmartAdminState,NumberOfStorageConnectivityErrors ISmartAdminState,NumberOfSqlErrors ISmartAdminState,NumberOfInvalidCredentialErrors ISmartAdminState,NumberOfOtherErrors ISmartAdminState,NumberOfCorruptedOrDeletedBackups ISmartAdminState,NumberOfBackupLoops ISmartAdminState,NumberOfRetentionLoops Statistic,FileGroup Statistic,ID Statistic,IsAutoCreated Statistic,IsFromIndexCreation Statistic,LastUpdated Statistic,NoAutomaticRecomputation Statistic,FilterDefinition Statistic,HasFilter Statistic,IsTemporary Statistic,Name StoredProcedure,AnsiNullsStatus StoredProcedure,CreateDate StoredProcedure,ForReplication StoredProcedure,ID StoredProcedure,ImplementationType StoredProcedure,IsEncrypted StoredProcedure,IsSchemaBound StoredProcedure,IsSystemObject StoredProcedure,Owner StoredProcedure,QuotedIdentifierStatus StoredProcedure,Recompile StoredProcedure,Startup StoredProcedure,AssemblyName StoredProcedure,ClassName StoredProcedure,ExecutionContext StoredProcedure,ExecutionContextPrincipal StoredProcedure,IsSchemaOwned StoredProcedure,MethodName StoredProcedure,IsNativelyCompiled StoredProcedure,Schema StoredProcedure,Name ISurfaceAreaFacet,AdHocRemoteQueriesEnabled ISurfaceAreaFacet,DatabaseMailEnabled ISurfaceAreaFacet,ClrIntegrationEnabled ISurfaceAreaFacet,OleAutomationEnabled ISurfaceAreaFacet,RemoteDacEnabled ISurfaceAreaFacet,SqlMailEnabled ISurfaceAreaFacet,WebAssistantEnabled ISurfaceAreaFacet,XPCmdShellEnabled ISurfaceAreaFacet,ServiceBrokerEndpointActive ISurfaceAreaFacet,SoapEndpointsEnabled ISurfaceAreaConfigurationForAnalysisServer,AdHocDataMiningQueriesEnabled ISurfaceAreaConfigurationForAnalysisServer,AnonymousConnectionsEnabled ISurfaceAreaConfigurationForAnalysisServer,LinkedObjectsLinksToOtherInstancesEnabled ISurfaceAreaConfigurationForAnalysisServer,LinkedObjectsLinksFromOtherInstancesEnabled ISurfaceAreaConfigurationForAnalysisServer,UserDefinedFunctionsEnabled ISurfaceAreaConfigurationForAnalysisServer,ListenOnlyOnLocalConnections ISurfaceAreaConfigurationForReportingServices,WebServiceAndHTTPAccessEnabled ISurfaceAreaConfigurationForReportingServices,ScheduleEventsAndReportDeliveryEnabled ISurfaceAreaConfigurationForReportingServices,ReportManagerEnabled SymmetricKey,CreateDate SymmetricKey,DateLastModified SymmetricKey,EncryptionAlgorithm SymmetricKey,ID SymmetricKey,IsOpen SymmetricKey,KeyGuid SymmetricKey,KeyLength SymmetricKey,Owner SymmetricKey,ProviderName SymmetricKey,Name Synonym,BaseDatabase Synonym,BaseObject Synonym,BaseSchema Synonym,BaseServer Synonym,BaseType Synonym,CreateDate Synonym,DateLastModified Synonym,ID Synonym,IsSchemaOwned Synonym,Owner Synonym,Schema Synonym,Name Table,CreateDate Table,DataSpaceUsed Table,FakeSystemTable Table,FileGroup Table,HasClusteredIndex Table,HasSparseColumn Table,ID Table,IndexSpaceUsed Table,IsSystemObject Table,Owner Table,Replicated Table,RowCount Table,TextFileGroup Table,AnsiNullsStatus Table,HasAfterTrigger Table,HasDeleteTrigger Table,HasIndex Table,HasInsertTrigger Table,HasInsteadOfTrigger Table,HasUpdateTrigger Table,IsIndexable Table,QuotedIdentifierStatus Table,DateLastModified Table,HasHeapIndex Table,IsPartitioned Table,IsSchemaOwned Table,IsVarDecimalStorageFormatEnabled Table,PartitionScheme Table,ChangeTrackingEnabled Table,FileStreamFileGroup Table,FileStreamPartitionScheme Table,HasCompressedPartitions Table,LockEscalation Table,TrackColumnsUpdatedEnabled Table,FileTableDirectoryName Table,FileTableNameColumnCollation Table,FileTableNamespaceEnabled Table,IsFileTable Table,Durability Table,HasClusteredColumnStoreIndex Table,IsMemoryOptimized Table,DataSourceName Table,FileFormatName Table,HasSystemTimePeriod Table,HistoryTableID Table,HistoryTableName Table,HistoryTableSchema Table,IsExternal Table,IsSystemVersioned Table,Location Table,RejectSampleValue Table,RejectType Table,RejectValue Table,RemoteDataArchiveDataMigrationState Table,RemoteDataArchiveEnabled Table,RemoteDataArchiveFilterPredicate Table,RemoteTableName Table,RemoteTableProvisioned Table,SystemTimePeriodEndColumn Table,SystemTimePeriodStartColumn Table,TemporalType Table,IsEdge Table,IsNode Table,Schema Table,Name ITableOptions,AnsiNullsStatus ITableOptions,ChangeTrackingEnabled ITableOptions,CreateDate ITableOptions,FakeSystemTable ITableOptions,ID ITableOptions,IsSchemaOwned ITableOptions,IsSystemObject ITableOptions,LockEscalation ITableOptions,Name ITableOptions,Owner ITableOptions,QuotedIdentifierStatus ITableOptions,RemoteDataArchiveEnabled ITableOptions,RemoteDataArchiveDataMigrationState ITableOptions,RemoteTableName ITableOptions,RemoteTableProvisioned ITableOptions,Replicated ITableOptions,Schema ITableOptions,TrackColumnsUpdatedEnabled Trigger,AnsiNullsStatus Trigger,CreateDate Trigger,Delete Trigger,DeleteOrder Trigger,ID Trigger,ImplementationType Trigger,Insert Trigger,InsertOrder Trigger,InsteadOf Trigger,IsEnabled Trigger,IsEncrypted Trigger,IsSystemObject Trigger,NotForReplication Trigger,QuotedIdentifierStatus Trigger,Update Trigger,UpdateOrder Trigger,AssemblyName Trigger,ClassName Trigger,DateLastModified Trigger,ExecutionContext Trigger,ExecutionContextPrincipal Trigger,MethodName Trigger,IsNativelyCompiled Trigger,IsSchemaBound Trigger,Name User,CreateDate User,DateLastModified User,HasDBAccess User,ID User,IsSystemObject User,Login User,LoginType User,Sid User,UserType User,AsymmetricKey User,AuthenticationType User,Certificate User,DefaultSchema User,Name UserDefinedAggregate,AssemblyName UserDefinedAggregate,ClassName UserDefinedAggregate,CreateDate UserDefinedAggregate,DateLastModified UserDefinedAggregate,ID UserDefinedAggregate,IsSchemaOwned UserDefinedAggregate,Owner UserDefinedAggregate,Schema UserDefinedAggregate,Name UserDefinedDataType,AllowIdentity UserDefinedDataType,Default UserDefinedDataType,DefaultSchema UserDefinedDataType,ID UserDefinedDataType,Length UserDefinedDataType,MaxLength UserDefinedDataType,Nullable UserDefinedDataType,NumericPrecision UserDefinedDataType,NumericScale UserDefinedDataType,Owner UserDefinedDataType,Rule UserDefinedDataType,RuleSchema UserDefinedDataType,SystemType UserDefinedDataType,VariableLength UserDefinedDataType,Collation UserDefinedDataType,IsSchemaOwned UserDefinedDataType,Schema UserDefinedDataType,Name UserDefinedFunction,AnsiNullsStatus UserDefinedFunction,CreateDate UserDefinedFunction,FunctionType UserDefinedFunction,ID UserDefinedFunction,ImplementationType UserDefinedFunction,IsDeterministic UserDefinedFunction,IsEncrypted UserDefinedFunction,IsSchemaBound UserDefinedFunction,IsSystemObject UserDefinedFunction,Owner UserDefinedFunction,QuotedIdentifierStatus UserDefinedFunction,TableVariableName UserDefinedFunction,AssemblyName UserDefinedFunction,ClassName UserDefinedFunction,ExecutionContext UserDefinedFunction,ExecutionContextPrincipal UserDefinedFunction,IsSchemaOwned UserDefinedFunction,MethodName UserDefinedFunction,ReturnsNullOnNullInput UserDefinedFunction,IsNativelyCompiled UserDefinedFunction,Schema UserDefinedFunction,Name UserDefinedType,AssemblyName UserDefinedType,BinaryTypeIdentifier UserDefinedType,ClassName UserDefinedType,Collation UserDefinedType,ID UserDefinedType,IsBinaryOrdered UserDefinedType,IsComVisible UserDefinedType,IsFixedLength UserDefinedType,IsNullable UserDefinedType,IsSchemaOwned UserDefinedType,MaxLength UserDefinedType,NumericPrecision UserDefinedType,NumericScale UserDefinedType,Owner UserDefinedType,UserDefinedTypeFormat UserDefinedType,Schema UserDefinedType,Name IUserOptions,AsymmetricKey IUserOptions,Certificate IUserOptions,CreateDate IUserOptions,DefaultSchema IUserOptions,ID IUserOptions,IsSystemObject IUserOptions,Login IUserOptions,LoginType IUserOptions,Name IUserOptions,Sid IUserOptions,UserType UserDefinedTableType,Collation UserDefinedTableType,CreateDate UserDefinedTableType,DateLastModified UserDefinedTableType,ID UserDefinedTableType,IsSchemaOwned UserDefinedTableType,IsUserDefined UserDefinedTableType,MaxLength UserDefinedTableType,Nullable UserDefinedTableType,Owner UserDefinedTableType,IsMemoryOptimized UserDefinedTableType,Schema UserDefinedTableType,Name Utility,Name Utility,UtilityName Utility,MdwDatabaseName Utility,CreatedBy Utility,Description Utility,TotalStorageCapacity Utility,TotalStorageUtilization Utility,OverUtilizationTrailingWindow Utility,OverUtilizationOccurenceFrequency Utility,UnderUtilizationTrailingWindow Utility,UnderUtilizationOccurenceFrequency Utility,MdwRetentionLengthInDaysForMinutesHistory Utility,MdwRetentionLengthInDaysForHoursHistory Utility,MdwRetentionLengthInDaysForDaysHistory View,AnsiNullsStatus View,CreateDate View,HasColumnSpecification View,ID View,IsEncrypted View,IsSchemaBound View,IsSystemObject View,Owner View,QuotedIdentifierStatus View,HasAfterTrigger View,HasDeleteTrigger View,HasIndex View,HasInsertTrigger View,HasInsteadOfTrigger View,HasUpdateTrigger View,IsIndexable View,DateLastModified View,IsSchemaOwned View,ReturnsViewMetadata View,Schema View,Name IViewOptions,AnsiNullsStatus IViewOptions,CreateDate IViewOptions,ID IViewOptions,IsEncrypted IViewOptions,IsSchemaBound IViewOptions,IsSchemaOwned IViewOptions,IsSystemObject IViewOptions,Name IViewOptions,Owner IViewOptions,Schema IViewOptions,QuotedIdentifierStatus IViewOptions,ReturnsViewMetadata Volume,Name Volume,ID Volume,DeviceId Volume,TotalSpace Volume,TotalSpaceUsed Volume,TotalSpaceUtilization WorkloadGroup,GroupMaximumRequests WorkloadGroup,ID WorkloadGroup,Importance WorkloadGroup,IsSystemObject WorkloadGroup,MaximumDegreeOfParallelism WorkloadGroup,RequestMaximumCpuTimeInSeconds WorkloadGroup,RequestMaximumMemoryGrantPercentage WorkloadGroup,RequestMemoryGrantTimeoutInSeconds WorkloadGroup,ExternalResourcePoolName WorkloadGroup,Name XmlSchemaCollection,CreateDate XmlSchemaCollection,DateLastModified XmlSchemaCollection,ID XmlSchemaCollection,Text XmlSchemaCollection,Schema XmlSchemaCollection,Name