Table of contents
- Developing SQL-DMO Applications
-
SQL-DMO Reference
-
Objects
- A
- B
- C
-
D
- Database Object
- Database2 Object
- DatabaseRole Object
- DatabaseRole2 Object
- DBFile Object
- DBObject Object
- DBOption Object
- DBOption2 Object
- Default Object
- Default2 Object
- DistributionArticle Object
- DistributionArticle2 Object
- DistributionDatabase Object
- DistributionDatabase2 Object
- DistributionPublication Object
- DistributionPublication2 Object
- DistributionPublisher Object
- DistributionPublisher2 Object
- DistributionSubscription Object
- DistributionSubscription2 Object
- Distributor Object
- Distributor2 Object
- DRIDefault Object
- F
- I
- J
- K
- L
- M
- N
- O
- P
- Q
-
R
- RegisteredServer Object
- RegisteredSubscriber Object
- Registry Object
- Registry2 Object
- RemoteLogin Object
- RemoteServer Object
- RemoteServer2 Object
- Replication Object
- Replication2 Object
- ReplicationDatabase Object
- ReplicationDatabase2 Object
- ReplicationSecurity Object
- ReplicationStoredProcedure Object
- ReplicationStoredProcedure2 Object
- ReplicationTable Object
- ReplicationTable2 Object
- Restore Object
- Restore2 Object
- Rule Object
- Rule2 Object
- S
-
T
- Table Object
- Table2 Object
- TargetServer Object
- TargetServerGroup Object
- TransactionLog Object
- TransArticle Object
- TransArticle2 Object
- Transfer Object
- Transfer2 Object
- TransPublication Object
- TransPublication2 Object
- TransPullSubscription Object
- TransPullSubscription2 Object
- TransSubscription Object
- TransSubscription2 Object
- Trigger Object
- Trigger2 Object
- U
- V
- Collections
-
Properties
-
A
- Action Property (Backup)
- Action Property (Restore)
- ActiveEndDate Property
- ActiveEndTimeOfDay Property
- ActiveStartDate Property
- ActiveStartTimeOfDay Property
- AdditionalParameters Property
- Adsp Property
- AfterTrigger Property
- AgentCheckupInterval Property
- AgentLogFile Property
- AgentOffload Property
- AgentOffloadServer Property
- AgentsStatus Property
- Alias Property
- AllowDTS Property
- AllowIdentity Property
- AllowInteractiveResolver Property
- AllowLength Property
- AllowMergePublication Property
- AllowNulls Property
- AllowQueuedTransactions Property
- AllowSynchronousTransactions Property
- AllowSyncToAlternate Property
- AltSnapshotFolder Property
- AnsiNulls Property
- AnsiNullsStatus Property
- AnsiPaddingStatus Property
- ApplicationName Property
- AppRole Property
- ArticleResolver Property
- ArticleType Property
- AssignmentDiag Property
- Attributes Property
- AuditLevel Property
- AutoClose Property
- AutoCreateStat Property
- AutogenerateSyncProcedures Property
- AutoIdentityRange Property
- AutoReConnect Property
- AutoShrink Property
- AutoStart Property
- AutostartDTC Property
- AutostartLicensing Property
- AutostartMail Property
- AutostartServer Property
- AutoUpdateStat Property
- B
-
C
- CaseSensitive Property
- Catalog Property
- Category Property
- CentralizedConflicts Property
- CharacterSet Property
- Checked Property
- CheckPermissions Property
- Clustered Property
- CmdExecSuccessCode Property
- CodePage Property
- Collation Property
- CollationName Property
- ColumnDelimiter Property
- ColumnMaxLength Property
- ColumnName Property
- Columns Property
- ColumnsNullByDefault Property
- ColumnTracking Property
- ColumnType Property
- Command Property
- CommandOptions Property
- CommandTerminator Property
- CompareNull Property
- CompatibilityLevel Property (Database)
- CompatibilityLevel Property (MergePublication2, TransPublication2)
- ComputedText Property
- ConflictPolicy Property
- ConflictRetention Property
- ConflictTable Property
- ConnectionID Property
- ConnectTimeout Property
- ContactNull Property
- CopyAllDefaults Property
- CopyAllFunctions Property
- CopyAllObjects Property
- CopyAllRules Property
- CopyAllStoredProcedures Property
- CopyAllTables Property
- CopyAllTriggers Property
- CopyAllUserDefinedDatatypes Property
- CopyAllViews Property
- CopyData Property
- CopySchema Property
- Count Property
- CountResetDate Property
- CountResetTime Property
- CreateDate Property
- CreateForAttach Property
- CreationScriptOptions Property
- CreationScriptPath Property
- CurrentCompatibility Property
- CurrentExecutionStatus Property
- CurrentResultSet Property
- CurrentRunRetryAttempt Property
- CurrentRunStatus Property
- CurrentRunStep Property
- CurrentValue Property
- CursorCloseOnCommit Property
-
D
- Database Property
- DatabaseFileGroups Property
- DatabaseFiles Property
- DatabaseName Property
- DatabaseUserName Property
- DataFile Property
- DataFilePath Property
- DataFileSize Property
- DataFileType Property
- DataFolder Property
- DataSource Property
- DataSpaceUsage Property
- DataSpaceUsed Property
- Datatype Property
- DateCreated Property
- DateFindOperand Property
- DateJobCreated Property
- DateJobLastModified Property
- DateLastModified Property
- Day Property
- Days Property
- DboLogin Property
- DBOUseOnly Property
- DBOwner Property
- DBReadOnly Property
- Default Property (Column, UserDefinedDatatype)
- Default Property (FileGroup)
- DefaultCursor Property
- DefaultDomain Property
- DefaultLogin Property
- DefaultOwner Property
- DefaultPath Property
- DelayBetweenResponses Property
- DeleteCommand Property
- DeleteLevel Property
- DenyNTLogin Property
- Description Property
- DestDatabase Property
- DestinationObjectName Property
- DestinationOwnerName Property
- DestLogin Property
- DestPassword Property
- DestServer Property
- DestTranslateChar Property
- DestUseTrustedConnection Property
- DeviceNumber Property
- Devices Property
- DistributionAgent Property
- DistributionCleanupTaskName Property
- DistributionDatabase Property
- DistributionJobID Property
- DistributionServer Property
- DistributionWorkingDirectory Property
- Distributor Property
- DistributorAvailable Property
- DistributorInstalled Property
- DistributorLocal Property
- DropDestObjectsFirst Property
- DropLogins Property
- DTSPackageLocation Property
- DTSPackageName Property
- DTSPackagePassword Property
- DynamicFilterHostName Property
- DynamicFilterLogin Property
- DynamicFilters Property
- DynamicReconfigure Property
- DynamicSnapshotJobId Property
- DynamicSnapshotLocation Property
-
E
- EmailAddress Property
- EmailLevel Property
- EnableBcp Property
- Enabled Property
- EnabledForSyncMgr Property
- EnableMergePublishing Property
- EnableTransPublishing Property
- Encrypted Property
- EndRunDate Property
- EndRunTime Property
- EnlistDate Property
- ErrorFilePath Property
- ErrorLogPath Property
- ErrorLogSize Property
- EventCategoryID Property
- EventDescriptionKeyword Property
- EventID Property
- EventlogLevel Property
- EventSource Property
- ExcludeReplication Property
- ExpirationDate Property
- ExportWideChar Property
-
F
- FailSafeOperator Property
- FakeSystemTable Property
- FileGroup Property
- FileGrowth Property
- FileGrowthInKB Property
- FileGrowthType Property
- FileNumber Property
- Files Property
- FillFactor Property
- FilterClause Property
- FirstDayOfWeek Property
- FirstRow Property
- Flags Property
- FormatFilePath Property
- FormatMedia Property
- ForwardAlways Property
- ForwardingServer Property
- ForwardingSeverity Property
- FrequencyInterval Property
- FrequencyRecurrenceFactor Property
- FrequencySubDay Property
- FrequencySubDayInterval Property
- FrequencyType Property
- FTPAddress Property
- FTPLogin Property
- FTPPassword Property
- FTPPort Property
- FTPSubdirectory Property
- FullName Property
- FullSubscription Property
- FullTextCatalogID Property
- FullTextCatalogName Property
- FullTextColumnLanguageID Property
- FullTextImageColumnType Property
- FullTextIndex Property
- FullTextIndexActive Property
- FullTextIndexSize Property
- FullTextKeyColumn Property
- FullTextPopulateStatus Property
- G
-
H
- HasBigIntColumn Property
- HasBigIntIdentityColumn Property
- HasClusteredIndex Property
- HasDBAccess Property
- HasFullTextIndexedTables Property
- HasGuidColumn Property
- HasIdentityColumn Property
- HasIdentityNotForReplColumn Property
- HasIndex Property
- HasNotification Property
- HasPrimaryKey Property
- HasRemoteDistributionPublisher Property
- HasRowVersionColumn Property
- HasSchedule Property
- HasServer Property
- HasSQLVariantColumn Property
- HasStep Property
- HasSubscription Property
- HasTimeStampColumn Property
- HistoryCleanupTaskName Property
- HistoryRetention Property
- HostName Property
-
I
- ID Property
- ID Property (DistributionArticle2)
- Identity Property
- IdentityIncrement Property
- IdentityRangeThreshold Property
- IdentitySeed Property
- Impersonate Property
- ImpersonateClient Property
- ImportRowsPerBatch Property
- InActiveDirectory Property
- InAlter Property
- IncludeDB Property
- IncludeDependencies Property
- IncludeEventDescription Property
- IncludeIdentityValues Property
- IncludeLogins Property
- IncludeUsers Property
- IndexedColumns Property
- IndexOnTable Property
- IndexSpaceUsage Property
- IndexSpaceUsed Property
- Initialize Property
- InPrimaryKey Property
- InsertCommand Property
- InstanceName Property
- InsteadOfTrigger Property
- Isbulkadmin Property
- IsClustered Property
- IsComputed Property
- Isdb_accessadmin Property
- Isdb_backupoperator Property
- Isdb_datareader Property
- Isdb_datawriter Property
- Isdb_ddladmin Property
- Isdb_denydatareader Property
- Isdb_denydatawriter Property
- Isdb_owner Property
- Isdb_securityadmin Property
- Isdbcreator Property
- IsDeleted Property
- IsDeterministic Property
- Isdiskadmin Property
- IsDistributionPublisher Property
- IsFullTextEnabled Property
- IsFullTextInstalled Property
- IsFullTextKey Property
- IsNumeric Property
- IsOnComputed Property
- Isprocessadmin Property
- IsRowGuidCol Property
- IsSchemaBound Property
- Issecurityadmin Property
- Isserveradmin Property
- Issetupadmin Property
- Issysadmin Property
- IsVariableLength Property
- ItemCount Property
- J
- K
-
L
- LangDateFormat Property
- Language Property
- LanguageAlias Property
- LastBackup Property
- LastDistributionDate Property
- LastDistributionStatus Property
- LastDistributionSummary Property
- LastDistributionSummaryTime Property
- LastEmailDate Property
- LastEmailTime Property
- LastMergedStatus Property
- LastMergedSummary Property
- LastMergedTime Property
- LastNetSendDate Property
- LastNetSendTime Property
- LastOccurrenceDate Property
- LastOccurrenceTime Property
- LastPageDate Property
- LastPageTime Property
- LastPollDate Property
- LastResponseDate Property
- LastResponseTime Property
- LastRestore Property
- LastRow Property
- LastRunDate Property
- LastRunDuration Property
- LastRunOutcome Property
- LastRunRetries Property
- LastRunTime Property
- Length Property
- LoadHistory Property
- LocalLogin Property
- LocalName Property
- LocalTime Property
- Location Property (LinkedServer)
- Location Property (TargetServer)
- LogFile Property
- LogFilePath Property
- LogFileSize Property
- LogFolder Property
- Login Property
- LoginSecure Property
- LoginTimeout Property
- LogReaderAgent Property
-
M
- MailAccountName Property
- MailPassword Property
- MasterDBPath Property
- MaxConcurrentMerge Property
- MaxConcurrentDynamicSnapshots Property
- MaxDistributionRetention Property
- MaximumChar Property
- MaximumErrorsBeforeAbort Property
- MaximumLength Property
- MaximumSize Property
- MaximumValue Property
- MaxNumericPrecision Property
- MaxSize Property
- MediaDescription Property
- MediaName Property
- MediaPassword Property
- MergeJobID Property
- MessageID Property
- MinDistributionRetention Property
- MinimumRetries Property
- MinimumRunDuration Property
- MinimumValue Property
- Month Property
- Months Property
- MSXServerName Property
- MultipleColumnUpdate Property
-
N
- Name Property
- NetName Property
- NetPacketSize Property
- NetSendAddress Property
- NetSendLevel Property
- NextDeviceNumber Property
- NextRunDate Property
- NextRunScheduleID Property
- NextRunTime Property
- NoRecompute Property
- NoRewind Property
- NotForRepl Property
- NotificationMessage Property
- NotificationMethod Property
- NP Property
- NTEventLogging Property
- NTLoginAccessType Property
- NumberOfProcessors Property
- NumericPrecision Property
- NumericScale Property
-
O
- ObjectID Property
- ObjectName Property
- ObjectOwner Property
- ObjectType Property
- ObjectTypeName Property
- OccurrenceCount Property
- ODBCPrefix Property
- ODBCVersionString Property
- Offline Property
- OldestFirst Property
- OnFailAction Property
- OnFailStep Property
- OnSuccessAction Property
- OnSuccessStep Property
- OperatorToEmail Property
- OperatorToNetSend Property
- OperatorToPage Property
- Options Property
- OriginatingServer Property
- OSRunPriority Property
- OutcomeTypes Property
- OutputFileName Property
- Owner Property (Database, UserDefinedFunction)
- Owner Property (Database Objects)
- Owner Property (Job, JobFilter)
-
P
- PageLevel Property
- PagerAddress Property
- PagerCCTemplate Property
- PagerDays Property
- PagerSendSubjectOnly Property
- PagerSubjectTemplate Property
- PagerToTemplate Property
- Parent Property
- Password Property
- PendingInstructions Property
- PercentCompleteNotification Property
- PerfMonMode Property
- PerformanceCondition Property
- Permissions Property
- PersistFlags Property
- PhysicalDatatype Property
- PhysicalLocation Property
- PhysicalMemory Property
- PhysicalName Property
- PID Property
- Pipes Property
- PollingInterval Property
- PopulateCompletionAge Property
- PopulateCompletionDate Property
- PopulateStatus Property
- PostSnapshotScript Property
- PreCreationMethod Property
- PreSnapshotScript Property
- PrimaryFile Property
- PrimaryFilePath Property
- Priority Property
- PrivilegeType Property
- PrivilegeTypeName Property
- ProcessID Property
- ProcessInputBuffer Property
- ProcessOutputBuffer Property
- ProductLevel Property
- ProductName Property
- ProviderName Property
- ProviderString Property
- Publication Property
- PublicationAttributes Property
- PublicationDB Property
- PublicationType Property
- PublishedInMerge Property
- PublishedInQueuedTransactions Property
- Publisher Property
- PublisherIdentityRangeSize Property
- Q
-
R
- ReadOnly Property
- RecoveryModel Property
- RecursiveTriggers Property
- ReferencedKey Property
- ReferencedTable Property
- RegionalSetting Property
- RegisteredOrganization Property
- RegisteredOwner Property
- RelocateFiles Property
- RemoteName Property
- RemotePassword Property
- RemoteUser Property
- ReplaceDatabase Property
- ReplicateAllColumns Property
- ReplicationFilterProcName Property
- ReplicationFilterProcOwner Property
- ReplicationFrequency Property
- ReplicationInstalled Property
- ResolverInfo Property
- ResourceUsage Property
- Restart Property
- ResultSets Property
- RetainDays Property
- RetentionPeriod Property
- RetryAttempts Property
- RetryInterval Property
- Role Property
- RootPath Property
- RowDelimiter Property
- Rows Property
- RpcEncrypt Property
- RpcList Property
- RpcMaxCalls Property
- RpcMinCalls Property
- Rule Property
- RuleOwner Property
- RunningValue Property
-
S
- SaLogin Property
- SaturdayPagerEndTime Property
- SaturdayPagerStartTime Property
- ScheduleID Property
- Script2Type Property
- ScriptType Property
- SecurityMode Property (DistributionDatabase, IntegratedSecurity)
- SecurityMode Property (ReplicationSecurity)
- SelectIntoBulkCopy Property
- Server Property
- ServerBCPDataFileType Property
- ServerBCPKeepIdentity Property
- ServerBCPKeepNulls Property
- ServerID Property
- ServerName Property
- ServiceName Property
- Set Property
- SetHostName Property
- Severity Property
- ShortMonth Property
- ShortMonths Property
- ShowAdvancedOptions Property
- SingleUser Property
- Size Property
- SizeInKB Property
- SkipTapeHeader Property
- SkipTapeLabel Property
- SnapshotAgent Property
- SnapshotAvailable Property
- SnapshotJobID Property
- SnapshotMethod Property
- SnapshotObjectName Property
- SnapshotObjectOwner Property
- SNMP Property
- SNMPCurrentVersion Property
- SNMPExtensionAgents Property
- SNMPExtensionAgentsData Property
- SortOrder Property
- SourceObjectName Property
- SourceObjectOwner Property
- SourceTranslateChar Property
- SpaceAllocatedOnFiles Property
- SpaceAvailable Property
- SpaceAvailableInMB Property
- SpaceUsed Property
- SpxFlag Property
- SpxPort Property
- SpxServiceName Property
- SQLCurrentVersion Property
- SQLDataRoot Property
- SQLMessageID Property
- SQLRootPath Property
- SQLSeverity Property
- StandardLogin Property
- StandardPassword Property
- StandbyFiles Property
- StartRunDate Property
- StartRunTime Property
- StartStepID Property
- Startup Property
- StartupAccount Property
- Status Property (BackupDevice)
- Status Property (Database)
- Status Property (MergeArticle)
- Status Property (Services)
- Status Property (Subscription Objects)
- Status Property (TargetServer)
- StatisticsIndex Property
- StatusInfoRefetchInterval Property
- StepID Property
- StepSubsystem Property
- Subscriber Property
- SubscriberIdentityRangeSize Property
- SubscriberLogin Property
- SubscriberPassword Property
- SubscriberSecurityMode Property
- SubscriberType Property (MergePullSubscription, MergeSubscription)
- SubscriberType Property (TransPullSubscription, TransSubscription)
- SubscriptionDB Property
- SubscriptionID Property
- SubscriptionType Property
- SubsetFilterClause Property
- SubSystem Property
- SundayPagerEndTime Property
- SundayPagerStartTime Property
- SuperSocketEncrypt Property
- SuperSocketList Property
- SuspendIndexing Property
- SyncType Property
- SystemObject Property
-
T
- TableFullTextChangeTrackingOn Property
- TableFullTextUpdateIndexOn Property
- TableLock Property
- TapeLoadWaitTime Property
- Tapes Property
- TcpFlag Property
- TcpPort Property
- Text Property
- TextFileGroup Property
- ThirdParty Property
- ThirdPartyOptions Property
- TimeZoneAdjustment Property
- ToPointInTime Property
- TopologyX Property
- TopologyY Property
- TornPageDetection Property
- TranslateChar Property
- TrueLogin Property
- TrueName Property
- TruncateLog Property (Backup)
- TruncateLog Property (BulkCopy)
- TruncateLogOnCheckpoint Property
- Trusted Property
- TrustedDistributorConnection Property
- Type Property (Alert)
- Type Property (BackupDevice)
- Type Property (Category)
- Type Property (DBObject)
- Type Property (Index)
- Type Property (Job, JobFilter)
- Type Property (JobServer)
- Type Property (Key)
- Type Property (Login)
- Type Property (Property)
- Type Property (RegisteredSubscriber)
- Type Property (StoredProcedure)
- Type Property (Trigger)
- Type Property (UserDefinedFunction)
- TypeName Property
- TypeOf Property
-
U
- UniqueIndexForFullText Property
- UniqueKeyCount Property
- UnloadTapeAfter Property
- UpdateCommand Property
- Upgrade Property
- Use6xCompatible Property
- UseBulkCopyOption Property
- UseCollation Property
- UseCurrentUserServerGroups Property
- UseDestTransaction Property
- UseExistingConnection Property
- UseFTP Property
- UseInteractiveResolver Property
- UserData Property
- UserName Property
- UserProfile Property
- UseServerSideBCP Property
- UseTrustedConnection Property
-
V
- ValidateSubscriberInfo Property
- Value Property
- VendorName Property
- VerifyResolverSignature Property
- Version Property
- VersionBuild Property
- VersionMajor Property
- VersionMinor Property
- VersionNumber Property
- VersionString Property
- ViaListenInfo Property
- ViaRecognizedVendors Property
- ViaVendor Property
- VinesGroupName Property
- VinesItemName Property
- VinesOrgName Property
- W
-
A
-
Methods
-
A
- Abort Method
- ActivateSubscriptions Method
- Add Method
- AddAlternatePublisher Method
- AddMember Method
- AddMemberServer Method
- AddNotification Method
- AddObject Method
- AddObjectByName Method
- AddReplicatedColumns Method
- AddStartParameter Method
- AddStepToJob Method
- Alter Method
- AlterDataType Method
- ApplyToTargetServer Method
- ApplyToTargetServerGroup Method
- AttachDB Method
- AttachDBWithSingleFile Method
- AttachDBWithSingleFile2 Method
- AttachSubscriptionDatabase Method
- B
-
C
- CancelAlter Method
- ChangeAgentParameter Method
- ChangeAgentProfile Method
- CheckAllocations Method
- CheckAllocationsDataOnly Method
- CheckAllocationsDataOnlyWithResult Method
- CheckAllocationsWithResult Method
- CheckCatalog Method
- CheckCatalogWithResult Method
- CheckDefaultSyntax Method
- CheckFilegroup Method
- CheckFilegroupDataOnly Method
- CheckFileGroupDataOnlyWithResult Method
- CheckFileGroupWithResult Method
- CheckIdentityValue Method
- CheckIdentityValues Method
- CheckIndex Method
- CheckIndexWithResult Method
- Checkpoint Method
- CheckRuleSyntax Method
- CheckTable Method
- CheckTableDataOnly Method
- CheckTableDataOnlyWithResult Method
- CheckTables Method
- CheckTablesDataOnly Method
- CheckTablesDataOnlyWithResult Method
- CheckTablesWithResult Method
- CheckTableWithResult Method
- CleanUp Method
- CleanUpAnonymousAgentInfo Method
- CleanUpDistributionPublisherByName Method
- Close Method
- CommandShellImmediate Method
- CommandShellWithResults Method
- CommitTransaction Method
- Connect Method
- Continue Method
- CopySnapshot Method (MergePublication2)
- CopySnapshot Method (TransPublication2)
- CopySubscriptionDatabase Method
- CreateAgentProfile Method
-
D
- DeleteAgentProfile Method
- Deny Method (Database)
- Deny Method (StoredProcedure)
- Deny Method (Table, View)
- Deny Method (UserDefinedFunction)
- DetachDB Method
- DetachedDBInfo Method
- DisableAgentOffload Method
- DisableFullTextCatalogs Method
- DisableMergeSubscription Method
- DisableTransSubscription Method
- DisConnect Method
- DoAlter Method
- DoAlterWithNoCheck Method
- DropMember Method
-
E
- EnableAgentOffload Method
- EnableFullTextCatalogs Method
- EnableMergeSubscription Method
- EnableTransSubscription Method
- EnumAccountInfo Method
- EnumAgentErrorRecords Method
- EnumAgentParameters Method
- EnumAgentProfiles Method
- EnumAlerts Method
- EnumAllSubscriptions Method
- EnumAllSubsetFilters Method
- EnumAlternatePublishers Method
- EnumAvailableMedia Method
- EnumCandidateKeys Method
- EnumCollations Method
- EnumColumns Method
- EnumConflictTables Method
- EnumCustomResolvers Method
- EnumDatabaseMappings Method
- EnumDatabaseRoleMember Method
- EnumDataSourceNames Method
- EnumDependencies Method
- EnumDirectories Method
- EnumDistributionAgentSessionDetails Method
- EnumDistributionAgentSessionDetails2 Method
- EnumDistributionAgentSessions Method
- EnumDistributionAgentSessions2 Method
- EnumDistributionAgentViews Method
- EnumDistributionAgentViews2 Method
- EnumErrorLogs Method
- EnumFileGroups Method
- EnumFiles Method (Database)
- EnumFiles Method (FileGroup)
- EnumFixedDatabaseRolePermission Method
- EnumFullTextLanguages Method
- EnumGeneratedSubsetFilters Method
- EnumHistory Method
- EnumIdentityRangeInfo Method
- EnumInitialAccesses Method
- EnumJobHistory Method
- EnumJobInfo Method
- EnumJobNotifications Method
- EnumJobs Method
- EnumLastStatisticsUpdates Method
- EnumLocks Method
- EnumLoginMappings Method
- EnumLogReaderAgentSessionDetails Method
- EnumLogReaderAgentSessionDetails2 Method
- EnumLogReaderAgentSessions Method
- EnumLogReaderAgentSessions2 Method
- EnumLogReaderAgentView Method
- EnumLogReaderAgentViews Method
- EnumMatchingSPs Method
- EnumMergeAgentSessionDetails Method
- EnumMergeAgentSessionDetails2 Method
- EnumMergeAgentSessions Method
- EnumMergeAgentSessions2 Method
- EnumMergeAgentViews Method
- EnumMergeAgentViews2 Method
- EnumMiscellaneousAgentViews Method
- EnumNotifications Method
- EnumNTDomainGroups Method
- EnumNTGroups Method
- EnumObjects Method
- EnumOutputs Method
- EnumParameters Method
- EnumProcesses Method
- EnumPublicationAccesses Method
- EnumPublicationArticles Method
- EnumPublicationReferences Method
- EnumPublications Method
- EnumPublications2 Method
- EnumQueueReaderAgentSessionDetails Method
- EnumQueueReaderAgentSessions Method
- EnumQueueReaderAgentView Method
- EnumQueueReaderAgentViews Method
- EnumReferencedKeys Method
- EnumReferencedTables Method
- EnumReferencingKeys Method
- EnumReferencingTables Method
- EnumServerAttributes Method
- EnumServerRoleMember Method
- EnumServerRolePermission Method
- EnumSnapshotAgentSessionDetails Method
- EnumSnapshotAgentSessionDetails2 Method
- EnumSnapshotAgentSessions Method
- EnumSnapshotAgentSessions2 Method
- EnumSnapshotAgentView Method
- EnumSnapshotAgentViews Method
- EnumStatistics Method
- EnumSubscriptions Method
- EnumSubscriptionViews Method
- EnumSubscriptionViews2 Method
- EnumSubSystems Method
- EnumTables Method
- EnumTargetServers Method
- EnumThirdPartyPublications Method
- EnumThirdPartyPublications2 Method
- EnumThirdPartyVendorNames Method
- EnumUsers Method
- EnumVersionInfo Method
- ExecuteImmediate Method (Database, SQLServer)
- ExecuteImmediate Method (LinkedServer, RemoteServer)
- ExecuteWithResults Method
- ExecuteWithResultsAndMessages Method
- ExecuteWithResultsAndMessages2 Method
- ExportData Method
- F
-
G
- GenerateCreationSQL Method
- GenerateCreationSQLOnView Method
- GenerateFilters Method
- GenerateSQL Method (Backup, Restore)
- GenerateSQL Method (Database)
- GenerateSQL Method (FullTextCatalog)
- GenerateSQL Method (Index)
- GenerateSQL Method (Table, UserDefinedDatatype)
- GenerateSQLOnView Method
- GetAgentsStatus Method (DistributionPublication, DistributionPublisher)
- GetAgentsStatus Method (Distributor)
- GetAgentsStatus2 Method (DistributionPublication2, DistributionPublisher2)
- GetAgentsStatus2 Method (Distributor2)
- GetColumnBigInt Method
- GetColumnBinary Method
- GetColumnBinaryLength Method
- GetColumnBool Method
- GetColumnDate Method
- GetColumnDouble Method
- GetColumnFloat Method
- GetColumnGUID Method
- GetColumnLong Method
- GetColumnSQLVARIANT Method
- GetColumnSQLVARIANTDataType Method
- GetColumnSQLVARIANTLength Method
- GetColumnSQLVARIANTToString Method
- GetColumnString Method
- GetDatatypeByName Method
- GetIndexedColumnDESC Method
- GetJobByID Method
- GetMemoryUsage Method
- GetObjectByName Method
- GetRangeString Method
- GetUserName Method
- Grant Method (Database)
- Grant Method (StoredProcedure, UserDefinedFunction)
- Grant Method (Table, View)
- GrantPublicationAccess Method
-
I
- ImportData Method
- Insert Method
- InsertColumn Method
- Install Method
- Invoke Method
- IsDetachedPrimaryFile Method
- IsFixedRole Method
- IsLogin Method
- IsMember Method
- IsNTGroupMember Method
- IsObjectDeleted Method
- IsOS Method
- IsPackage Method
- IsUser Method
- IsValidKeyDatatype Method
- Item Method
- ItemByID Method
- K
-
L
- ListAvailableSQLServers Method
- ListAvailableUniqueIndexesForFullText Method
- ListBoundColumns Method
- ListBoundDatatypes Method
- ListCollations Method
- ListColumns Method
- ListCompatibilityLevels Method
- ListDatabasePermissions Method
- ListDetachedDBFiles Method
- ListDetachedLogFiles Method
- ListIndexedColumns Method
- ListInstalledInstances Method
- ListKeys Method
- ListMembers Method (Login, User)
- ListMembers Method (SQLServer)
- ListMemberServers Method
- ListObjectPermissions Method
- ListObjectNames Method
- ListObjects Method
- ListOwnedObjects Method
- ListPermissions Method
- ListPrivilegeColumns Method
- ListReplicatedColumns Method
- ListStartupProcedures Method
- ListUserColumnPermissions Method
- ListUserPermissions Method
- M
- P
- Q
-
R
- ReadAgentOffloadInfo Method
- ReadBackupHeader Method (BackupDevice)
- ReadBackupHeader Method (Restore)
- ReadBackupHeader Method (SQLServer)
- ReadErrorLog Method
- ReadFileList Method
- ReadLastValidationDateTimes Method
- ReadMediaHeader Method (BackupDevice)
- ReadMediaHeader Method (Restore)
- ReadReplicationFailOverMode Method
- ReAssignJobsByLogin Method
- Rebuild Method
- RebuildIndex Method
- RebuildIndexes Method
- RecalcSpaceUsage Method
- ReCompileReferences Method
- ReconfigureCurrentValues Method
- ReconfigureWithOverride Method
- ReConnect Method
- Refresh Method
- RefreshChildren Method
- ReInitialize Method
- ReInitialize2 Method
- ReInitializeAllSubscriptions Method
- ReInitializeAllSubscriptions2 Method
- Remove Method (Objects)
- Remove Method (Collections)
- Remove Method (Operator)
- Remove Method (Operators)
- RemoveAllJobSchedules Method
- RemoveAllJobSteps Method
- RemoveAllObjects Method
- RemoveAlternatePublisher Method
- RemoveDefunctAnonymousSubscription Method
- RemoveFromTargetServer Method
- RemoveFromTargetServerGroup Method
- RemoveFullTextCatalogs Method
- RemoveJobByID Method
- RemoveJobsByLogin Method
- RemoveJobsByServer Method
- RemoveMemberServer Method
- RemoveNotification Method
- RemoveReplicatedColumns Method
- Replace Method
- ReplicateUserDefinedScript Method
- ReplicationAddColumn Method
- ReplicationDropColumn Method
- ResetOccurrenceCount Method
- ReSynchronizeSubscription Method
- Revoke Method (Database)
- Revoke Method (StoredProcedure)
- Revoke Method (Table, View)
- Revoke Method (UserDefinedFunction)
- RevokePublicationAccess Method
- RollbackTransaction Method
-
S
- SaveTransaction Method
- Script Method
- Script Method (BackupDevice Object)
- Script Method (Replication Objects)
- Script Method (Table Object)
- ScriptDestinationObject Method
- ScriptDestinationObject2 Method (MergeArticle2)
- ScriptTransfer Method
- ServerLoginMode Method
- SetCodePage Method
- SetFullTextIndexWithOptions Method
- SetIndexedColumnDESC Method
- SetOptions Method
- SetOwner Method
- SetPassword Method
- SetTopologyXY Method
- SetUpDistributorPassword Method
- Shrink Method
- Shutdown Method
- SQLBackup Method
- SQLRestore Method
- SQLVerify Method
- Start Method (FullTextCatalog)
- Start Method (FullTextService, JobServer)
- Start Method (Job)
- Start Method (SQLServer)
- StartMonitor Method
- Stop Method
- StopMonitor Method
- T
-
U
- UnbindFromColumn Method
- UnbindFromDatatype Method
- Uninstall Method
- UnloadODSDLL Method
- UpdateAgentProfile Method
- UpdateDefaultAgentProfile Method
- UpdateIndexStatistics Method
- UpdateNotification Method
- UpdateStatistics Method
- UpdateStatisticsWith Method (Column, Index)
- UpdateStatisticsWith Method (Table)
- V
- W
-
A
-
Events
- BatchImported Event
- CommandSent Event
- ConnectionBroken Event
- Complete Event
- NextMedia Event
- PercentComplete Event
- PercentCompleteAtStep Event
- QueryTimeout Event
- RemoteLoginFailed Event
- RowsCopied Event
- ScriptTransferPercentComplete Event
- ServerMessage Event
- StatusMessage Event
- TransferPercentComplete Event
-
Constants
- A
- B
- C
-
D
- Database Compression Constants (SQLDMO_SHRINK_TYPE)
- Database Repair Constants (SQLDMO_DBCC_REPAIR_TYPE)
- Database Statistics Affected Constants (SQLDMO_STAT_AFFECT_TYPE)
- Database Statistics Scanning Constants (SQLDMO_STAT_SCAN_TYPE)
- Database Status Constants (SQLDMO_DBSTATUS_TYPE)
- Database User Profile Constants (SQLDMO_DBUSERPROFILE_TYPE)
- Data Copy Constants (SQLDMO_COPYDATA_TYPE)
- Day of Week Constants (SQLDMO_WEEKDAY_TYPE)
- Dependency Constants (SQLDMO_DEPENDENCY_TYPE)
- Device Type Constants (SQLDMO_DEVICE_TYPE)
- E
-
F
- File Growth Constants (SQLDMO_GROWTH_TYPE)
- Find Operand Constants (SQLDMO_FIND_OPERAND)
- Full-Text Service Population Status Constants (SQLDMO_FULLTEXT_POPULATE_STATUS)
- Full-Text Service Population Type Constants (SQLDMO_FULLTEXT_POPULATE_TYPE)
- Full-text Service Start Constants (SQLDMO_FULLTEXT_START_TYPE)
- Full-text Service Status Constants (SQLDMO_FULLTEXTSTATUS_TYPE)
- G
- I
-
J
- Job Category Constants (SQLDMO_CATEGORYTYPE_TYPE)
- Job Completion Constants (SQLDMO_COMPLETION_TYPE)
- Job Execution Status Constants (SQLDMO_JOBEXECUTION_STATUS)
- Job Outcome Constants (SQLDMO_JOBOUTCOME_TYPE)
- Job Step OS Priority Constants (SQLDMO_RUNPRIORITY_TYPE)
- Job Scope Constants (SQLDMO_JOB_TYPE)
- Job Step Action Constants (SQLDMO_JOBSTEPACTION_TYPE)
- K
- L
- M
- N
- O
- P
-
R
- Recovery Model Constants (SQLDMO_RECOVERY_TYPE)
- Replication Agent Constants (SQLDMO_REPLAGENT_TYPE)
- Replication Article Command Option Constants (SQLDMO_COMMANDOPTION_TYPE)
- Replication Article Constants (SQLDMO_ARTICLE_TYPE)
- Replication Article Pre-Creation Constants (SQLDMO_PREARTICLE_TYPE)
- Replication Article Status Constants (SQLDMO_ARTSTATUS_TYPE)
- Replication Compatibility Level Constants (SQLDMO_REPLCOMPLEVEL_TYPE)
- Replication Conflict Policy Constants (SQLDMO_CONFLICTPOLICY_TYPE)
- Replication Conflict Resolution Constants (SQLDMO_RESOLVECONFLICT_TYPE)
- Replication Constants (SQLDMO_REPLCONSTANTS_TYPE)
- Replication DTS Package Constants (SQLDMO_REPLDTSLOC_TYPE)
- Replication Failover Mode Constants (SQLDMO_REPLFAILOVER_TYPE)
- Replication Frequency Constants (SQLDMO_REPFREQ_TYPE)
- Replication Initial Synchronization Constants (SQLDMO_INITIALSYNC_TYPE)
- Replication Merge Subscriber Constants (SQLDMO_MERGESUBSCRIBER_TYPE)
- Replication Method Constants (SQLDMO_REPLICATION_TYPE)
- Replication Object Creation Script Constants (SQLDMO_CREATIONSCRIPT_TYPE)
- Replication Permissions Checking Constants (SQLDMO_CHECKPERMISSIONS_TYPE)
- Replication Publication Attribute Constants (SQLDMO_PUBATTRIB_TYPE)
- Replication Publication Constants (SQLDMO_PUBLICATION_TYPE)
- Replication Publication Status Constants (SQLDMO_PUBSTATUS_TYPE)
- Replication Queue Type Constants (SQLDMO_REPLQUEUE_TYPE)
- Replication Resynchronization Constants (SQLDMO_RESYNC_TYPE)
- Replication Script Constants (SQLDMO_REPSCRIPT_TYPE)
- Replication Security Constants (SQLDMO_REPLSECURITY_TYPE)
- Replication Signature Verification Constants (SQLDMO_VERIFYSIGNATURE_TYPE)
- Replication Subscriber Constants (SQLDMO_SUBSCRIBER_TYPE)
- Replication Subscription Constants (SQLDMO_SUBSCRIPTION_TYPE)
- Replication Subscription Status Constants (SQLDMO_SUBSTATUS_TYPE)
- Replication Subscription Synchronization Constants (SQLDMO_SUBSYNC_TYPE)
- Replication Task Status Constants (SQLDMO_TASKSTATUS_TYPE)
- Replication Third-Party Publication Display Option Constants (SQLDMO_THIRDPARTYOPTION_TYPE)
- Replication Transactional Subscriber Constants (SQLDMO_TRANSUBSCRIBER_TYPE)
- Replication Validation Method Constants (SQLDMO_VALIDATIONMETHOD_TYPE)
- Replication Validation Option Constants (SQLDMO_VALIDATIONOPTION_TYPE)
- Restore Process Control Constants (SQLDMO_RESTORE_TYPE)
- Role Constants (SQLDMO_DBUSERROLE_TYPE)
- Role Type Constants (SQLDMO_ROLE_TYPE)
-
S
- Scheduling Frequency Constants (SQLDMO_FREQUENCY_TYPE)
- Scheduling Relative Frequency Constants (SQLDMO_FREQRELATIVE_TYPE)
- Scheduling Subfrequency Constants (SQLDMO_FREQSUB_TYPE)
- Security Constants (SQLDMO_SECURITY_TYPE)
- Session Constants (SQLDMO_SESSION_TYPE)
- Server Option Constants (SQLDMO_SRVOPTION_TYPE)
- Server User Profile Constants (SQLDMO_SRVUSERPROFILE_TYPE)
- SQL Server Agent Type Constants (SQLDMO_JOBSERVER_TYPE)
- SQL Server Connection Constants (SQLDMO_VERIFYCONN_TYPE)
- SQL Server Data Type Constants (SQLDMO_QUERY_DATATYPE)
- SQL Server Installed Product Constants (SQLDMO_PACKAGE_TYPE)
- SQL Server Version Constants (SQLDMO_SQL_VER)
- SQL-DMO Object Type Constants (SQLDMO_OBJECT_TYPE)
- Statement Execution Constants (SQLDMO_EXEC_TYPE)
- Status Information Constants (SQLDMO_STATUSINFO_TYPE)
- T
- U
- W
- C/C++ Specifics
- SQL-DMO Samples
- SQL-DMO Examples
-
Objects