Developing SQL-DMO Applications
Getting Started with SQL-DMO
SQL-DMO Syntax Conventions
System Requirements for SQL-DMO
Installing SQL-DMO
SQL-DMO Objects and SQL Server Administration
SQL-DMO Object
Object Properties
Object Methods
Object Events
Creating SQL Server Components Using SQL-DMO Objects
SQL-DMO Objects and Existing SQL Server Components
Programming Extended SQL-DMO Objects
Using SQL-DMO Multistrings
SQL-DMO Collections and SQL Server Administration
SQL-DMO Collections
Collection Properties
Collection Methods
Creating SQL Server Components Using SQL-DMO Collections
Removing SQL Server Components Using SQL-DMO Collections
Description of the SQLServer Object
Creating and Connecting a SQLServer Object
SQL-DMO Object Tree
Developing SQL-DMO Applications Using Visual Basic
Object Creation
Properties Collection
SQL-DMO Constants
Handling SQL-DMO Events
Handling SQL-DMO Errors
Developing SQL-DMO Applications Using C or C++
Objects, References, and Reference Counting
Object Creation
Member Functions (Properties and Methods)
SQL-DMO Strings
SQL-DMO Properties Collection
SQL-DMO Data Types
Handling SQL-DMO Events
Handling SQL-DMO Errors
SQL-DMO Reference
Objects
A
Alert Object
AlertSystem Object
Application Object
B
Backup Object
Backup2 Object
BackupDevice Object
BulkCopy Object
BulkCopy2 Object
C
Category Object
Check Object
Column Object
Column2 Object
Configuration Object
ConfigValue Object
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
FileGroup Object
FileGroup2 Object
FullTextCatalog Object
FullTextCatalog2 Object
FullTextService Object
I
Index Object
Index2 Object
IntegratedSecurity Object
J
Job Object
JobFilter Object
JobHistoryFilter Object
JobSchedule Object
JobServer Object
JobServer2 Object
JobStep Object
K
Key Object
L
Language Object
LinkedServer Object
LinkedServer2 Object
LinkedServerLogin Object
LogFile Object
Login Object
Login2 Object
M
MergeArticle Object
MergeArticle2 Object
MergeDynamicSnapshotJob Object
MergePublication Object
MergePublication2 Object
MergePullSubscription Object
MergePullSubscription2 Object
MergeSubscription Object
MergeSubscription2 Object
MergeSubsetFilter Object
N
NameList Object
O
Operator Object
P
Permission Object
Permission2 Object
Property Object
Publisher Object
Publisher2 Object
Q
QueryResults Object
QueryResults2 Object
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
Schedule Object
ServerGroup Object
ServerRole Object
SQLObjectList Object
SQLServer Object
SQLServer2 Object
StoredProcedure Object
StoredProcedure2 Object
Subscriber Object
Subscriber2 Object
SystemDatatype Object
SystemDataType2 Object
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
User Object
User2 Object
UserDefinedDatatype Object
UserDefinedDataType2 Object
UserDefinedFunction Object
V
View Object
View2 Object
Collections
A
AlertCategories Collection
Alerts Collection
B
BackupDevices Collection
C
Checks Collection
Columns Collection
ConfigValues Collection
D
DatabaseRoles Collection
Databases Collection
DBFiles Collection
Defaults Collection
DistributionArticles Collection
DistributionDatabases Collection
DistributionPublications Collection
DistributionPublishers Collection
DistributionSubscriptions Collection
F
FileGroups Collection
FullTextCatalogs Collection
I
Indexes Collection
J
JobCategories Collection
Jobs Collection
JobSchedules Collection
JobSteps Collection
K
Keys Collection
L
Languages Collection
LinkedServerLogins Collection
LinkedServers Collection
LogFiles Collection
LogFiles2 Collection
Logins Collection
M
MergeArticles Collection
MergeDynamicSnapshotJobs Collection
MergePublications Collection
MergePullSubscriptions Collection
MergeSubscriptions Collection
MergeSubsetFilters Collection
N
Names Collection
O
OperatorCategories Collection
Operators Collection
P
Properties Collection
R
RegisteredServers Collection
RegisteredSubscribers Collection
RemoteLogins Collection
RemoteServers Collection
ReplicationDatabases Collection
ReplicationStoredProcedures Collection
ReplicationTables Collection
Rules Collection
S
ServerGroups Collection
ServerRoles Collection
SQLServers Collection
StoredProcedures Collection
SystemDatatypes Collection
T
Tables Collection
TargetServerGroups Collection
TargetServers Collection
TransArticles Collection
TransPublications Collection
TransPullSubscriptions Collection
TransSubscriptions Collection
Triggers Collection
U
UserDefinedDatatypes Collection
UserDefinedFunctions Collection
Users Collection
V
Views Collection
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
BackupDirectory Property
BackupSetDescription Property
BackupSetName Property
BaseType Property
BlockingTimeout Property
BlockSize Property
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
Get Property
Granted Property
GrantedGranted Property
Grantee Property
GroupID Property
GroupRegistrationServer Property
GroupRegistrationVersion Property
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
JobID Property
JobName Property
JoinArticleName Property
JoinFilterClause Property
JoinUniqueKey Property
K
KeepPartitionChanges Property
KeepReplication Property
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
QueryTimeout Property
QueueType Property
QuoteDelimiter Property
QuotedIdentifier Property
QuotedIdentifierStatus Property
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
WeekdayPagerEndTime Property
WeekdayPagerStartTime Property
WorkingDirectory Property
WSProxyAddress Property
WSProxyPort Property
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
BeginAlter Method
BeginTransaction Method
BindDefault Method
BindRule Method
BindToColumn Method
BindToDatatype Method
BrowseSnapshotFolder Method (MergePublication2)
BrowseSnapshotFolder Method (TransPublication2)
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
FindName Method
FullTextIndexScript Method
FullTextPopulation Method
FullTextUpdateIndex Method
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
KillDatabase Method
KillProcess Method
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
MSXDefect Method
MSXEnlist Method
P
Pause Method
PingSQLServerVersion Method
PurgeHistory Method
PurgeJobHistory Method
Q
Quit Method
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
Transfer Method
Truncate Method
TruncateData Method
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
ValidateDataSource Method
ValidatePublication Method (MergePublication2)
ValidatePublication Method (TransPublication2)
ValidateSubscription Method
ValidateSubscriptions Method
VerifyConnection Method
W
WriteReplicationFailOverMode Method
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
Alert Constants (SQLDMO_ALERT_TYPE)
Audit Constants (SQLDMO_AUDIT_TYPE)
B
Backup Process Control Constants (SQLDMO_BACKUP_TYPE)
Bulk Copy Code Page Constants (SQLDMO_BCP_CODEPAGE_TYPE)
Bulk Copy Data Constants (SQLDMO_DATAFILE_TYPE)
Bulk Copy Server Data File Constants (SQLDMO_SERVERBCP_DATAFILE_TYPE)
C
Compatibility Level Constants (SQLDMO_COMP_LEVEL_TYPE)
Configuration Value Constants (SQLDMO_CONFIGVALUE_TYPE)
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
Error Constants (SQLDMO_ERROR_TYPE)
Event Type Constants (SQLDMO_EVENT_TYPE)
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
Grant Type Constants (SQLDMO_GRANTED_TYPE)
I
Index Constants (SQLDMO_INDEX_TYPE)
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
Key Type Constants (SQLDMO_KEY_TYPE)
L
Linked Table Type Constants (SQLDMO_LINKEDTABLE_TYPE)
List Sorting Constants (SQLDMO_OBJSORT_TYPE)
Login Type Constants (SQLDMO_LOGIN_TYPE)
M
Media Type Constants (SQLDMO_MEDIA_TYPE)
Miscellaneous Constants (SQLDMO_CONSTANTS_TYPE)
Month and Day (Relative Scheduling) Constants (SQLDMO_MONTHDAY_TYPE)
N
Notification Enumeration Constants (SQLDMO_ENUMNOTIFY_TYPE)
Notification Method Constants (SQLDMO_NOTIFY_TYPE)
O
Object Scripting Constants (SQLDMO_SCRIPT_TYPE)
Object Scripting Constants (SQLDMO_SCRIPT2_TYPE)
Operating System Type Constants (SQLDMO_OS_TYPE)
P
Performance Monitor Constants (SQLDMO_PERFMON_TYPE)
Privilege Constants (SQLDMO_PRIVILEGE_TYPE)
Procedure Constants (SQLDMO_PROCEDURE_TYPE)
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
Table Attribute Constants (SQLDMO_TABLEATT_TYPE)
Target Server Status Constants (SQLDMO_TARGETSERVERSTATUS_TYPE)
Transaction Log Backup Constants (SQLDMO_BACKUP_LOG_TYPE)
Transfer Script Mode Constants (SQLDMO_XFRSCRIPTMODE_TYPE)
Trigger Constants (SQLDMO_TRIGGER_TYPE)
U
User-Defined Function Constants (SQLDMO_UDF_TYPE)
W
Windows NT Access Constants (SQLDMO_NTACCESS_TYPE)
Windows NT Authentication Constants (SQLDMO_INTSECLOGIN_TYPE)
Windows NT Service Constants (SQLDMO_SVCSTATUS_TYPE)
C/C++ Specifics
Object Class Identifiers and Type Definitions
A
B
C
D
F
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
Scope-aware Template Classes
CTempBSTR
CTempOLERef
C/C++ Shortcuts
Collection Handling
Defined List Types
Helpful Macros
SQL-DMO Samples
AxSQLDMOCtl
BackRestEvents (Visual Basic)
BackRestEvents (C++)
BackupDevice
CreateDatabase
CreateTable
DMOExplorer
Dmoping
Enums
Explore
Idxtest
Login
Registry
Service
Smartptr
Soc
Socpp
SQLScripts
VerifyBackup
SQL-DMO Examples
SQL-DMO Examples: Alerts and Notification
Creating Alerts
Handling Raised Alerts (Notification)
SQL-DMO Examples: Backup and Restore
Backing Up a Database
Backing up Selected Portions of a Database
Scripting a Database Backup For Scheduled Execution
Database Restore
SQL-DMO Examples: Databases
Altering a Database by Adding a Database File
Creating a Database
SQL-DMO Examples: Full-text Indexing
SQL-DMO Examples: Indexes
SQL-DMO Examples: Jobs and Schedules
Creating SQL Server Agent Jobs
Controlling Job Step Logic
Targeting SQL Server Agent Jobs
Scheduling SQL Server Agent Jobs
SQL-DMO Examples: Tables
Altering a Table by Adding a Column
Altering a Table by Adding a FOREIGN KEY Constraint
Altering a Table by Adding a PRIMARY KEY Constraint
Creating a Table