sqldmo_tlb.pas

SQL SERVER 数据备份与恢复组件

const
  SQLDMOIndex_Default = $00000000;
  SQLDMOIndex_IgnoreDupKey = $00000001;
  SQLDMOIndex_Unique = $00000002;
  SQLDMOIndex_Clustered = $00000010;
  SQLDMOIndex_PadIndex = $00000100;
  SQLDMOIndex_SortedData = $00000200;
  SQLDMOIndex_SortedDataReorg = $00002000;
  SQLDMOIndex_DropExist = $00008000;
  SQLDMOIndex_Valid = $0000A313;
  SQLDMOIndex_Hypothetical = $00000020;
  SQLDMOIndex_DRIPrimaryKey = $00000800;
  SQLDMOIndex_DRIUniqueKey = $00001000;
  SQLDMOIndex_DRIIndex = $00001800;
  SQLDMOIndex_NoRecompute = $01000000;

// Constants for enum SQLDMO_QUERY_DATATYPE
type
  SQLDMO_QUERY_DATATYPE = TOleEnum;
const
  SQLDMO_DTypeUnknown = $00000000;
  SQLDMO_DTypeChar = $00000001;
  SQLDMO_DTypeText = $FFFFFFFF;
  SQLDMO_DTypeVarchar = $0000000C;
  SQLDMO_DTypeVarBinary = $FFFFFFFD;
  SQLDMO_DTypeBinary = $FFFFFFFE;
  SQLDMO_DTypeImage = $FFFFFFFC;
  SQLDMO_DTypeFloat4 = $00000007;
  SQLDMO_DTypeFloat8 = $00000008;
  SQLDMO_DTypeInt1 = $FFFFFFFA;
  SQLDMO_DTypeInt2 = $00000005;
  SQLDMO_DTypeInt4 = $00000004;
  SQLDMO_DTypeMoney4 = $00000003;
  SQLDMO_DTypeMoney = $00000003;
  SQLDMO_DTypeDateTime = $FFFFFFFE;
  SQLDMO_DTypeDateTime4 = $0000005D;
  SQLDMO_DTypeBit = $FFFFFFF9;
  SQLDMO_DTypeUChar = $FFFFFFF8;
  SQLDMO_DTypeUVarchar = $FFFFFFF7;
  SQLDMO_DTypeGUID = $FFFFFFF5;
  SQLDMO_DTypeNText = $FFFFFFF6;
  SQLDMO_DTypeBigint = $FFFFFFFB;
  SQLDMO_DTypeSQLVariant = $FFFFFF6A;

// Constants for enum SQLDMO_AUDIT_TYPE
type
  SQLDMO_AUDIT_TYPE = TOleEnum;
const
  SQLDMOAudit_None = $00000000;
  SQLDMOAudit_Success = $00000001;
  SQLDMOAudit_Failure = $00000002;
  SQLDMOAudit_All = $00000003;

// Constants for enum SQLDMO_SECURITY_TYPE
type
  SQLDMO_SECURITY_TYPE = TOleEnum;
const
  SQLDMOSecurity_Min = $00000000;
  SQLDMOSecurity_Normal = $00000000;
  SQLDMOSecurity_Integrated = $00000001;
  SQLDMOSecurity_Mixed = $00000002;
  SQLDMOSecurity_Max = $00000002;
  SQLDMOSecurity_Unknown = $00000009;

// Constants for enum SQLDMO_MEDIA_TYPE
type
  SQLDMO_MEDIA_TYPE = TOleEnum;
const
  SQLDMOMedia_Floppy = $00000001;
  SQLDMOMedia_FixedDisk = $00000002;
  SQLDMOMedia_Tape = $00000004;
  SQLDMOMedia_CDROM = $00000008;
  SQLDMOMedia_All = $0000000F;
  SQLDMOMedia_SharedFixedDisk = $00000010;

// Constants for enum SQLDMO_PERFMON_TYPE
type
  SQLDMO_PERFMON_TYPE = TOleEnum;
const
  SQLDMOPerfmon_None = $000003E8;
  SQLDMOPerfmon_MinSet = $00000000;
  SQLDMOPerfmon_Continuous = $00000000;
  SQLDMOPerfmon_OnDemand = $00000001;
  SQLDMOPerfmon_MaxSet = $00000001;

// Constants for enum SQLDMO_DBSTATUS_TYPE
type
  SQLDMO_DBSTATUS_TYPE = TOleEnum;
const
  SQLDMODBStat_Normal = $00000000;
  SQLDMODBStat_Loading = $00000020;
  SQLDMODBStat_Recovering = $000000C0;
  SQLDMODBStat_Suspect = $00000100;
  SQLDMODBStat_Offline = $00000200;
  SQLDMODBStat_Inaccessible = $000003E0;
  SQLDMODBStat_EmergencyMode = $00008000;
  SQLDMODBStat_Standby = $00000400;
  SQLDMODBStat_All = $000087E0;

// Constants for enum SQLDMO_COPYDATA_TYPE
type
  SQLDMO_COPYDATA_TYPE = TOleEnum;
const
  SQLDMOCopyData_False = $00000000;
  SQLDMOCopyData_Replace = $00000001;
  SQLDMOCopyData_Append = $00000002;

// Constants for enum SQLDMO_DATAFILE_TYPE
type
  SQLDMO_DATAFILE_TYPE = TOleEnum;
const
  SQLDMODataFile_CommaDelimitedChar = $00000001;
  SQLDMODataFile_Default = $00000001;
  SQLDMODataFile_TabDelimitedChar = $00000002;
  SQLDMODataFile_SpecialDelimitedChar = $00000003;
  SQLDMODataFile_NativeFormat = $00000004;
  SQLDMODataFile_UseFormatFile = $00000005;

// Constants for enum SQLDMO_STATUSINFO_TYPE
type
  SQLDMO_STATUSINFO_TYPE = TOleEnum;
const
  SQLDMOStatInfo_Unknown = $00000000;
  SQLDMOStatInfo_DatabaseStatus = $00000001;
  SQLDMOStatInfo_DatabaseSpace = $00000002;
  SQLDMOStatInfo_AutoVerifyConnection = $00000004;
  SQLDMOStatInfo_All = $00000007;

// Constants for enum SQLDMO_SCRIPT_TYPE
type
  SQLDMO_SCRIPT_TYPE = TOleEnum;
const
  SQLDMOScript_None = $00000000;
  SQLDMOScript_Default = $00000004;
  SQLDMOScript_Drops = $00000001;
  SQLDMOScript_ObjectPermissions = $00000002;
  SQLDMOScript_PrimaryObject = $00000004;
  SQLDMOScript_ClusteredIndexes = $00000008;
  SQLDMOScript_Triggers = $00000010;
  SQLDMOScript_DatabasePermissions = $00000020;
  SQLDMOScript_Permissions = $00000022;
  SQLDMOScript_ToFileOnly = $00000040;
  SQLDMOScript_Bindings = $00000080;
  SQLDMOScript_AppendToFile = $00000100;
  SQLDMOScript_NoDRI = $00000200;
  SQLDMOScript_UDDTsToBaseType = $00000400;
  SQLDMOScript_IncludeIfNotExists = $00001000;
  SQLDMOScript_NonClusteredIndexes = $00002000;
  SQLDMOScript_Indexes = $00012008;
  SQLDMOScript_Aliases = $00004000;
  SQLDMOScript_NoCommandTerm = $00008000;
  SQLDMOScript_DRIIndexes = $00010000;
  SQLDMOScript_IncludeHeaders = $00020000;
  SQLDMOScript_OwnerQualify = $00040000;
  SQLDMOScript_TimestampToBinary = $00080000;
  SQLDMOScript_SortedData = $00100000;
  SQLDMOScript_SortedDataReorg = $00200000;
  SQLDMOScript_TransferDefault = $000670FF;
  SQLDMOScript_DRI_NonClustered = $00400000;
  SQLDMOScript_DRI_Clustered = $00800000;
  SQLDMOScript_DRI_Checks = $01000000;
  SQLDMOScript_DRI_Defaults = $02000000;
  SQLDMOScript_DRI_UniqueKeys = $04000000;
  SQLDMOScript_DRI_ForeignKeys = $08000000;
  SQLDMOScript_DRI_PrimaryKey = $10000000;
  SQLDMOScript_DRI_AllKeys = $1C000000;
  SQLDMOScript_DRI_AllConstraints = $1F000000;
  SQLDMOScript_DRI_All = $1FC00000;
  SQLDMOScript_DRIWithNoCheck = $20000000;
  SQLDMOScript_NoIdentity = $40000000;
  SQLDMOScript_UseQuotedIdentifiers = $80000000;

// Constants for enum SQLDMO_SCRIPT2_TYPE
type
  SQLDMO_SCRIPT2_TYPE = TOleEnum;
const
  SQLDMOScript2_Default = $00000000;
  SQLDMOScript2_AnsiPadding = $00000001;
  SQLDMOScript2_AnsiFile = $00000002;
  SQLDMOScript2_UnicodeFile = $00000004;
  SQLDMOScript2_NonStop = $00000008;
  SQLDMOScript2_NoFG = $00000010;
  SQLDMOScript2_MarkTriggers = $00000020;
  SQLDMOScript2_OnlyUserTriggers = $00000040;
  SQLDMOScript2_EncryptPWD = $00000080;
  SQLDMOScript2_SeparateXPs = $00000100;
  SQLDMOScript2_NoWhatIfIndexes = $00000200;
  SQLDMOScript2_AgentNotify = $00000400;
  SQLDMOScript2_AgentAlertJob = $00000800;
  SQLDMOScript2_FullTextIndex = $00080000;
  SQLDMOScript2_LoginSID = $00100000;
  SQLDMOScript2_FullTextCat = $00200000;
  SQLDMOScript2_ExtendedProperty = $00400000;
  SQLDMOScript2_NoCollation = $00800000;
  SQLDMOScript2_70Only = $01000000;
  SQLDMOScript2_JobDisable = $02000000;
  SQLDMOScript2_ExtendedOnly = $04000000;
  SQLDMOScript2_DontScriptJobServer = $08000000;

// Constants for enum SQLDMO_XFRSCRIPTMODE_TYPE
type
  SQLDMO_XFRSCRIPTMODE_TYPE = TOleEnum;
const
  SQLDMOXfrFile_Default = $00000001;
  SQLDMOXfrFile_SummaryFiles = $00000001;
  SQLDMOXfrFile_SingleFile = $00000002;
  SQLDMOXfrFile_SingleFilePerObject = $00000004;
  SQLDMOXfrFile_SingleSummaryFile = $00000008;

// Constants for enum SQLDMO_DEPENDENCY_TYPE
type
  SQLDMO_DEPENDENCY_TYPE = TOleEnum;
const
  SQLDMODep_Parents = $00000000;
  SQLDMODep_FullHierarchy = $00010000;
  SQLDMODep_OrderDescending = $00020000;
  SQLDMODep_Children = $00040000;
  SQLDMODep_ReturnInputObject = $00080000;
  SQLDMODep_FirstLevelOnly = $00100000;
  SQLDMODep_DRIOnly = $00200000;
  SQLDMODep_IncludeSystem = $00400000;
  SQLDMODep_Valid = $007F0000;

// Constants for enum SQLDMO_OBJSORT_TYPE
type
  SQLDMO_OBJSORT_TYPE = TOleEnum;
const
  SQLDMOObjSort_Name = $00000000;
  SQLDMOObjSort_Type = $00000001;
  SQLDMOObjSort_Owner = $00000002;
  SQLDMOObjSort_Date = $00000003;

// Constants for enum SQLDMO_SVCSTATUS_TYPE
type
  SQLDMO_SVCSTATUS_TYPE = TOleEnum;
const
  SQLDMOSvc_Unknown = $00000000;
  SQLDMOSvc_Running = $00000001;
  SQLDMOSvc_Paused = $00000002;
  SQLDMOSvc_Stopped = $00000003;
  SQLDMOSvc_Starting = $00000004;
  SQLDMOSvc_Stopping = $00000005;
  SQLDMOSvc_Continuing = $00000006;
  SQLDMOSvc_Pausing = $00000007;

// Constants for enum SQLDMO_SRVOPTION_TYPE
type
  SQLDMO_SRVOPTION_TYPE = TOleEnum;
const
  SQLDMOSrvOpt_Unknown = $00000000;
  SQLDMOSrvOpt_RPC = $00000001;
  SQLDMOSrvOpt_Publisher = $00000002;
  SQLDMOSrvOpt_Subscriber = $00000004;
  SQLDMOSrvOpt_Distributor = $00000008;
  SQLDMOSrvOpt_DistPublisher = $00000010;
  SQLDMOSrvOpt_RPC_out = $00000040;
  SQLDMOSrvOpt_DataAccess = $00000080;
  SQLDMOSrvOpt_CollationCompatible = $00000100;
  SQLDMOSrvOpt_UseRemoteCollation = $00000400;
  SQLDMOSrvOpt_LazySchemaValid = $00000800;
  SQLDMOSrvOpt_NonTransacted = $00001000;
  SQLDMOSrvOpt_InProcess = $00002000;
  SQLDMOSrvOpt_IndexAsAccessPath = $00004000;
  SQLDMOSrvOpt_LevelZeroOnly = $00008000;
  SQLDMOSrvOpt_NestedQueries = $00010000;
  SQLDMOSrvOpt_DynamicParameters = $00020000;

// Constants for enum SQLDMO_TABLEATT_TYPE
type
  SQLDMO_TABLEATT_TYPE = TOleEnum;
const
  SQLDMOTabAtt_Identity = $00000001;
  SQLDMOTabAtt_SystemObject = $00000002;
  SQLDMOTabAtt_ForeignKey = $00000004;
  SQLDMOTabAtt_Referenced = $00000008;
  SQLDMOTabAtt_Published = $00000020;
  SQLDMOTabAtt_Replicated = $00000040;
  SQLDMOTabAtt_Check = $00000080;
  SQLDMOTabAtt_Replica = $00000100;
  SQLDMOTabAtt_PrimaryKey = $00000200;
  SQLDMOTabAtt_Unique = $00000400;
  SQLDMOTabAtt_Default = $00000800;
  SQLDMOTabAtt_ReplCheck = $00001000;
  SQLDMOTabAtt_HasConstraint = $00001C84;

// Constants for enum SQLDMO_INTSECLOGIN_TYPE
type
  SQLDMO_INTSECLOGIN_TYPE = TOleEnum;
const
  SQLDMOIntSecLogin_Unknown = $00000000;
  SQLDMOIntSecLogin_Min = $00000001;
  SQLDMOIntSecLogin_Admin = $00000001;
  SQLDMOIntSecLogin_User = $00000002;
  SQLDMOIntSecLogin_Replication = $00000003;
  SQLDMOIntSecLogin_Max = $00000003;

// Constants for enum SQLDMO_VERIFYCONN_TYPE
type
  SQLDMO_VERIFYCONN_TYPE = TOleEnum;
const
  SQLDMOConn_LastState = $00000001;