sqldmo_tlb.pas

SQL SERVER 数据备份与恢复组件

type
  SQLDMO_SHRINK_TYPE = TOleEnum;
const
  SQLDMOShrink_Default = $00000000;
  SQLDMOShrink_NoTruncate = $00000001;
  SQLDMOShrink_TruncateOnly = $00000002;
  SQLDMOShrink_EmptyFile = $00000003;

// Constants for enum SQLDMO_NTACCESS_TYPE
type
  SQLDMO_NTACCESS_TYPE = TOleEnum;
const
  SQLDMONTAccess_Unknown = $00000000;
  SQLDMONTAccess_Grant = $00000001;
  SQLDMONTAccess_Deny = $00000002;
  SQLDMONTAccess_NonNTLogin = $00000063;

// Constants for enum SQLDMO_FULLTEXT_POPULATE_TYPE
type
  SQLDMO_FULLTEXT_POPULATE_TYPE = TOleEnum;
const
  SQLDMOFullText_PopuFull = $00000000;
  SQLDMOFullText_PopuInc = $00000001;
  SQLDMOFullText_PopuStop = $00000002;

// Constants for enum SQLDMO_FULLTEXT_POPULATE_STATUS
type
  SQLDMO_FULLTEXT_POPULATE_STATUS = TOleEnum;
const
  SQLDMOFullText_Popu_No = $00000000;
  SQLDMOFullText_Popu_Full = $00000001;
  SQLDMOFullText_Popu_Inc = $00000002;

// Constants for enum SQLDMO_UDF_TYPE
type
  SQLDMO_UDF_TYPE = TOleEnum;
const
  SQLDMOUDF_Unknown = $00000000;
  SQLDMOUDF_Scalar = $00000001;
  SQLDMOUDF_Table = $00000002;
  SQLDMOUDF_Inline = $00000003;

// Constants for enum SQLDMO_RECOVERY_TYPE
type
  SQLDMO_RECOVERY_TYPE = TOleEnum;
const
  SQLDMORECOVERY_Simple = $00000000;
  SQLDMORECOVERY_BulkLogged = $00000001;
  SQLDMORECOVERY_Full = $00000002;
  SQLDMORECOVERY_Unknown = $00000003;

// Constants for enum SQLDMO_SUBSCRIBER_TYPE
type
  SQLDMO_SUBSCRIBER_TYPE = TOleEnum;
const
  SQLDMOSubInfo_SQLServer = $00000000;
  SQLDMOSubInfo_ODBCDatasource = $00000001;
  SQLDMOSubInfo_JetDatabase = $00000002;
  SQLDMOSubInfo_OLEDBDatasource = $00000003;
  SQLDMOSubInfo_ExchangeServer = $00000004;

// Constants for enum SQLDMO_INITIALSYNC_TYPE
type
  SQLDMO_INITIALSYNC_TYPE = TOleEnum;
const
  SQLDMOInitSync_Unknown = $0000000A;
  SQLDMOInitSync_Min = $00000000;
  SQLDMOInitSync_Default = $00000000;
  SQLDMOInitSync_BCPNative = $00000000;
  SQLDMOInitSync_BCPChar = $00000001;
  SQLDMOInitSync_Concurrent = $00000003;
  SQLDMOInitSync_ConcurrentChar = $00000004;
  SQLDMOInitSync_Max = $00000004;

// Constants for enum SQLDMO_REPFREQ_TYPE
type
  SQLDMO_REPFREQ_TYPE = TOleEnum;
const
  SQLDMORepFreq_Unknown = $000003E8;
  SQLDMORepFreq_Min = $00000000;
  SQLDMORepFreq_Continuous = $00000000;
  SQLDMORepFreq_Snapshot = $00000001;
  SQLDMORepFreq_Max = $00000001;

// Constants for enum SQLDMO_PUBLICATION_TYPE
type
  SQLDMO_PUBLICATION_TYPE = TOleEnum;
const
  SQLDMOPublication_Unknown = $000003E8;
  SQLDMOPublication_Min = $00000000;
  SQLDMOPublication_Transactional = $00000000;
  SQLDMOPublication_Snapshot = $00000001;
  SQLDMOPublication_Merge = $00000002;
  SQLDMOPublication_Max = $00000002;

// Constants for enum SQLDMO_ARTICLE_TYPE
type
  SQLDMO_ARTICLE_TYPE = TOleEnum;
const
  SQLDMORep_Min = $00000000;
  SQLDMORep_LogBased = $00000001;
  SQLDMORep_ManualFilterProc = $00000002;
  SQLDMORep_LogBasedManualFilterProc = $00000003;
  SQLDMORep_ManualSyncView = $00000004;
  SQLDMORep_LogBasedManualSyncView = $00000005;
  SQLDMORep_LogBasedVerticalPartition = $00000006;
  SQLDMORep_LogBasedManualBoth = $00000007;
  SQLDMORep_ProcExecution = $00000008;
  SQLDMORep_SerializableProcExecution = $00000018;
  SQLDMORep_TableBased = $0000000A;
  SQLDMORep_ProcSchemaOnly = $00000020;
  SQLDMORep_ViewSchemaOnly = $00000040;
  SQLDMORep_FuncSchemaOnly = $00000080;
  SQLDMORep_IndexedView = $00000100;
  SQLDMORep_IndexedViewLogBased = $00000101;
  SQLDMORep_IndexedViewLogBasedManualFilterProc = $00000103;
  SQLDMORep_IndexedViewLogBasedManualSyncView = $00000105;
  SQLDMORep_IndexedViewLogBasedManualBoth = $00000107;
  SQLDMORep_IndexedViewSchemaOnly = $00000140;
  SQLDMORep_Max = $00000140;

// Constants for enum SQLDMO_SUBSYNC_TYPE
type
  SQLDMO_SUBSYNC_TYPE = TOleEnum;
const
  SQLDMOSubSync_Unknown = $000003E8;
  SQLDMOSubSync_Manual = $00000000;
  SQLDMOSubSync_Min = $00000001;
  SQLDMOSubSync_Auto = $00000001;
  SQLDMOSubSync_Default = $00000001;
  SQLDMOSubSync_None = $00000002;
  SQLDMOSubSync_Max = $00000002;

// Constants for enum SQLDMO_PREARTICLE_TYPE
type
  SQLDMO_PREARTICLE_TYPE = TOleEnum;
const
  SQLDMOPreArt_Min = $00000000;
  SQLDMOPreArt_None = $00000000;
  SQLDMOPreArt_DropTable = $00000001;
  SQLDMOPreArt_DeleteRows = $00000002;
  SQLDMOPreArt_TruncateTable = $00000003;
  SQLDMOPreArt_Max = $00000003;

// Constants for enum SQLDMO_ARTSTATUS_TYPE
type
  SQLDMO_ARTSTATUS_TYPE = TOleEnum;
const
  SQLDMOArtStat_Min = $00000000;
  SQLDMOArtStat_Inactive = $00000000;
  SQLDMOArtStat_Unsynced = $00000001;
  SQLDMOArtStat_Active = $00000002;
  SQLDMOArtStat_Conflicts = $00000003;
  SQLDMOArtStat_Errors = $00000004;
  SQLDMOArtStat_NewInactive = $00000005;
  SQLDMOArtStat_NewActive = $00000006;
  SQLDMOArtStat_Max = $00000006;

// Constants for enum SQLDMO_SUBSTATUS_TYPE
type
  SQLDMO_SUBSTATUS_TYPE = TOleEnum;
const
  SQLDMOSubStat_Unknown = $000003E8;
  SQLDMOSubStat_Default = $000003E8;
  SQLDMOSubStat_Min = $00000000;
  SQLDMOSubStat_Inactive = $00000000;
  SQLDMOSubStat_Unsynced = $00000001;
  SQLDMOSubStat_Active = $00000002;
  SQLDMOSubStat_Max = $00000002;

// Constants for enum SQLDMO_PUBSTATUS_TYPE
type
  SQLDMO_PUBSTATUS_TYPE = TOleEnum;
const
  SQLDMOPubStat_Unknown = $000003E8;
  SQLDMOPubStat_Default = $000003E8;
  SQLDMOPubStat_Min = $00000000;
  SQLDMOPubStat_Inactive = $00000000;
  SQLDMOPubStat_Active = $00000001;
  SQLDMOPubStat_Max = $00000001;

// Constants for enum SQLDMO_REPLICATION_TYPE
type
  SQLDMO_REPLICATION_TYPE = TOleEnum;
const
  SQLDMORepType_Unknown = $00000100;
  SQLDMORepType_Transactional = $00000001;
  SQLDMORepType_Merge = $00000002;
  SQLDMORepType_TransactionalMerge = $00000003;
  SQLDMORepType_Default = $00000001;

// Constants for enum SQLDMO_RESOLVECONFLICT_TYPE
type
  SQLDMO_RESOLVECONFLICT_TYPE = TOleEnum;
const
  SQLDMOResolveConflict_Unknown = $00000100;
  SQLDMOResolveConflict_Resubmit = $00000001;
  SQLDMOResolveConflict_Discard = $00000002;
  SQLDMOResolveConflict_Default = $00000001;

// Constants for enum SQLDMO_TRANSUBSCRIBER_TYPE
type
  SQLDMO_TRANSUBSCRIBER_TYPE = TOleEnum;
const
  SQLDMOTranSubscriber_Unknown = $00000100;
  SQLDMOTranSubscriber_Min = $00000000;
  SQLDMOTranSubscriber_ReadOnly = $00000000;
  SQLDMOTranSubscriber_Synchronous = $00000001;
  SQLDMOTranSubscriber_Queued = $00000002;
  SQLDMOTranSubscriber_Failover = $00000003;
  SQLDMOTranSubscriber_Default = $00000000;
  SQLDMOTranSubscriber_Max = $00000003;

// Constants for enum SQLDMO_MERGESUBSCRIBER_TYPE
type
  SQLDMO_MERGESUBSCRIBER_TYPE = TOleEnum;
const
  SQLDMOMergeSubscriber_Unknown = $00000100;
  SQLDMOMergeSubscriber_Min = $00000001;
  SQLDMOMergeSubscriber_Global = $00000001;
  SQLDMOMergeSubscriber_Local = $00000002;
  SQLDMOMergeSubscriber_Anonymous = $00000003;
  SQLDMOMergeSubscriber_Republishing = $00000004;
  SQLDMOMergeSubscriber_Default = $00000002;
  SQLDMOMergeSubscriber_Max = $00000004;

// Constants for enum SQLDMO_REPSCRIPT_TYPE
type
  SQLDMO_REPSCRIPT_TYPE = TOleEnum;
const
  SQLDMORepScript_Default = $00000100;
  SQLDMORepScript_NoSubscription = $00000080;
  SQLDMORepScript_InstallDistributor = $00000100;
  SQLDMORepScript_UninstallDistributor = $00000200;
  SQLDMORepScript_InstallPublisher = $00000400;
  SQLDMORepScript_UninstallPublisher = $00000800;
  SQLDMORepScript_ToFileOnly = $00001000;
  SQLDMORepScript_AppendToFile = $00002000;
  SQLDMORepScript_Creation = $00004000;
  SQLDMORepScript_Deletion = $00008000;
  SQLDMORepScript_PublicationCreation = $00010000;
  SQLDMORepScript_PublicationDeletion = $00020000;
  SQLDMORepScript_SubscriptionCreation = $00040000;
  SQLDMORepScript_SubscriptionDeletion = $00080000;
  SQLDMORepScript_PullSubscriptionCreation = $00040000;
  SQLDMORepScript_PullSubscriptionDeletion = $00080000;
  SQLDMORepScript_InstallReplication = $00100000;
  SQLDMORepScript_UninstallReplication = $00200000;
  SQLDMORepScript_ReplicationJobs = $00400000;
  SQLDMORepScript_AnsiFile = $01000000;
  SQLDMORepScript_UnicodeFile = $02000000;
  SQLDMORepScript_EnableReplicationDB = $04000000;
  SQLDMORepScript_DisableReplicationDB = $08000000;
  SQLDMORepScript_NoCommandTerm = $10000000;

// Constants for enum SQLDMO_CREATIONSCRIPT_TYPE
type
  SQLDMO_CREATIONSCRIPT_TYPE = TOleEnum;
const
  SQLDMOCreationScript_DisableScripting = $00000000;
  SQLDMOCreationScript_PrimaryObject = $00000001;
  SQLDMOCreationScript_CustomProcs = $00000002;
  SQLDMOCreationScript_ClusteredIndexes = $00000010;
  SQLDMOCreationScript_UDDTsToBaseTypes = $00000020;
  SQLDMOCreationScript_NonClusteredIndexes = $00000040;
  SQLDMOCreationScript_DRI_PrimaryKey = $00000080;
  SQLDMOCreationScript_UserTriggers = $00000100;
  SQLDMOCreationScript_DRI_ForeignKeys = $00000200;
  SQLDMOCreationScript_DRI_Checks = $00000400;
  SQLDMOCreationScript_DRI_Defaults = $00000800;
  SQLDMOCreationScript_Collation = $00001000;
  SQLDMOCreationScript_ExtendedProperties = $00002000;
  SQLDMOCreationScript_DRI_UniqueKeys = $00004000;
  SQLDMOCreationScript_PKUKAsConstraints = $00008000;

// Constants for enum SQLDMO_COMMANDOPTION_TYPE
type
  SQLDMO_COMMANDOPTION_TYPE = TOleEnum;
const
  SQLDMOCommandOption_IncludeInsertColumnNames = $00000008;
  SQLDMOCommandOption_BinaryParameters = $00000010;
  SQLDMOCommandOption_DTSHorizontalPartition = $00000040;

// Constants for enum SQLDMO_SUBSCRIPTION_TYPE
type
  SQLDMO_SUBSCRIPTION_TYPE = TOleEnum;
const
  SQLDMOSubscription_Unknown = $00000100;
  SQLDMOSubscription_Min = $00000000;
  SQLDMOSubscription_Push = $00000000;
  SQLDMOSubscription_Pull = $00000001;
  SQLDMOSubscription_Anonymous = $00000002;
  SQLDMOSubscription_All = $00000003;
  SQLDMOSubscription_Default = $00000000;
  SQLDMOSubscription_Max = $00000003;

// Constants for enum SQLDMO_PUBATTRIB_TYPE
type
  SQLDMO_PUBATTRIB_TYPE = TOleEnum;
const
  SQLDMOPubAttrib_Unknown = $0