sqldmo_tlb.pas

SQL SERVER 数据备份与恢复组件

  SQLDMOConn_CurrentState = $00000002;
  SQLDMOConn_ReconnectIfDead = $00000006;
  SQLDMOConn_Valid = $00000007;

// Constants for enum SQLDMO_EXEC_TYPE
type
  SQLDMO_EXEC_TYPE = TOleEnum;
const
  SQLDMOExec_Default = $00000000;
  SQLDMOExec_NoCommandTerm = $00000001;
  SQLDMOExec_ContinueOnError = $00000002;
  SQLDMOExec_NoExec = $00000004;
  SQLDMOExec_ParseOnly = $00000008;
  SQLDMOExec_QI_ON = $00000010;

// Constants for enum SQLDMO_CONFIGVALUE_TYPE
type
  SQLDMO_CONFIGVALUE_TYPE = TOleEnum;
const
  SQLDMOConfig_RecoveryInterval = $00000065;
  SQLDMOConfig_AllowUpdates = $00000066;
  SQLDMOConfig_UserConnections = $00000067;
  SQLDMOConfig_Locks = $0000006A;
  SQLDMOConfig_OpenObjects = $0000006B;
  SQLDMOConfig_FillFactor = $0000006D;
  SQLDMOConfig_NestedTriggers = $00000073;
  SQLDMOConfig_RemoteAccess = $00000075;
  SQLDMOConfig_DefaultLanguage = $0000007C;
  SQLDMOConfig_LanguageInCache = $0000007D;
  SQLDMOConfig_MaxAsyncIO = $000001F6;
  SQLDMOConfig_MaxWorkerThreads = $000001F7;
  SQLDMOConfig_NetworkPacketSize = $000001F9;
  SQLDMOConfig_ShowAdvancedOption = $00000206;
  SQLDMOConfig_RemoteProcTrans = $0000021E;
  SQLDMOConfig_RemoteConnTimeout = $0000021F;
  SQLDMOConfig_DefaultSortorderId = $00000463;
  SQLDMOConfig_PriorityBoost = $000005ED;
  SQLDMOConfig_RemoteLoginTimeout = $000005EF;
  SQLDMOConfig_RemoteQueryTimeout = $000005F0;
  SQLDMOConfig_CursorThreshold = $000005FB;
  SQLDMOConfig_SetWorkingSetSize = $000005FC;
  SQLDMOConfig_UserOptions = $000005FE;
  SQLDMOConfig_ProcessorAffinityMask = $000005FF;
  SQLDMOConfig_MaxTextReplSize = $00000600;
  SQLDMOConfig_UnicodeLocalID = $00000464;
  SQLDMOConfig_UnicodeComparisonStyle = $00000465;
  SQLDMOConfig_LanguageNeutral = $00000466;
  SQLDMOConfig_TwoDigitYearCutoff = $00000467;
  SQLDMOConfig_IndexCreateMem = $000005E1;
  SQLDMOConfig_MediaRetention = $00000601;
  SQLDMOConfig_CostThresholdForParallelism = $00000602;
  SQLDMOConfig_MaxDegreeOfParallelism = $00000603;
  SQLDMOConfig_MimMemoryPerQuery = $00000604;
  SQLDMOConfig_QueryWait = $00000605;
  SQLDMOConfig_VLMSize = $00000606;
  SQLDMOConfig_MinMemory = $00000607;
  SQLDMOConfig_MaxMemory = $00000608;
  SQLDMOConfig_QueryMaxTime = $00000609;
  SQLDMOConfig_LightweightPooling = $0000060A;
  SQLDMOConfig_ScanStartup = $0000060B;

// Constants for enum SQLDMO_SRVUSERPROFILE_TYPE
type
  SQLDMO_SRVUSERPROFILE_TYPE = TOleEnum;
const
  SQLDMOSrvUserProf_None = $00000000;
  SQLDMOSrvUserProf_SaLogin = $00000001;
  SQLDMOSrvUserProf_CreateDatabase = $00000002;
  SQLDMOSrvUserProf_CreateXP = $00000004;
  SQLDMOSrvUserProf_AllProfileBits = $00000007;

// Constants for enum SQLDMO_DBUSERPROFILE_TYPE
type
  SQLDMO_DBUSERPROFILE_TYPE = TOleEnum;
const
  SQLDMODbUserProf_None = $00000000;
  SQLDMODbUserProf_DboLogin = $00000001;
  SQLDMODbUserProf_CreateTable = $00000002;
  SQLDMODbUserProf_CreateView = $00000004;
  SQLDMODbUserProf_CreateProcedure = $00000008;
  SQLDMODbUserProf_DumpDatabase = $00000010;
  SQLDMODbUserProf_CreateDefault = $00000020;
  SQLDMODbUserProf_DumpTransaction = $00000040;
  SQLDMODbUserProf_CreateRule = $00000080;
  SQLDMODbUserProf_DumpTable = $00000100;
  SQLDMODbUserProf_CreateFunction = $00000200;
  SQLDMODbUserProf_AllProfileBits = $000003FF;
  SQLDMODbUserProf_InvalidLogin = $40000000;
  SQLDMODbUserProf_InaccessibleDb = $80000000;
  SQLDMODbUserProf_DbNotAvailable = $C0000000;

// Constants for enum SQLDMO_OS_TYPE
type
  SQLDMO_OS_TYPE = TOleEnum;
const
  SQLDMO_WIN95 = $00000001;
  SQLDMO_WINNT = $00000002;

// Constants for enum SQLDMO_PACKAGE_TYPE
type
  SQLDMO_PACKAGE_TYPE = TOleEnum;
const
  SQLDMO_Unknown = $00000000;
  SQLDMO_OFFICE = $00000001;
  SQLDMO_STANDARD = $00000002;
  SQLDMO_ENTERPRISE = $00000003;
  SQLDMO_MSDE = $00000004;

// Constants for enum SQLDMO_CONSTANTS_TYPE
type
  SQLDMO_CONSTANTS_TYPE = TOleEnum;
const
  SQLDMO_NOENDDATE = $05F5BEBF;
  SQLDMO_NOENDTIME = $000399B7;
  SQLDMO_USEEXISTINGFILLFACTOR = $00000000;

// Constants for enum SQLDMO_LOGIN_TYPE
type
  SQLDMO_LOGIN_TYPE = TOleEnum;
const
  SQLDMOLogin_NTUser = $00000000;
  SQLDMOLogin_NTGroup = $00000001;
  SQLDMOLogin_Standard = $00000002;

// Constants for enum SQLDMO_ROLE_TYPE
type
  SQLDMO_ROLE_TYPE = TOleEnum;
const
  SQLDMORole_Server = $00000001;
  SQLDMORole_Database = $00000002;
  SQLDMORole_All = $00000003;

// Constants for enum SQLDMO_GRANTED_TYPE
type
  SQLDMO_GRANTED_TYPE = TOleEnum;
const
  SQLDMOGranted_GrantGrant = $000000CC;
  SQLDMOGranted_Grant = $000000CD;
  SQLDMOGranted_Deny = $000000CE;

// Constants for enum SQLDMO_BACKUP_LOG_TYPE
type
  SQLDMO_BACKUP_LOG_TYPE = TOleEnum;
const
  SQLDMOBackup_Log_Truncate = $00000000;
  SQLDMOBackup_Log_NoTruncate = $00000001;
  SQLDMOBackup_Log_NoLog = $00000002;
  SQLDMOBackup_Log_TruncateOnly = $00000003;
  SQLDMOBackup_Log_NoOption = $00000004;

// Constants for enum SQLDMO_BACKUP_TYPE
type
  SQLDMO_BACKUP_TYPE = TOleEnum;
const
  SQLDMOBackup_Database = $00000000;
  SQLDMOBackup_Differential = $00000001;
  SQLDMOBackup_Files = $00000002;
  SQLDMOBackup_Log = $00000003;

// Constants for enum SQLDMO_RESTORE_TYPE
type
  SQLDMO_RESTORE_TYPE = TOleEnum;
const
  SQLDMORestore_Database = $00000000;
  SQLDMORestore_Files = $00000001;
  SQLDMORestore_Log = $00000002;

// Constants for enum SQLDMO_DBUSERROLE_TYPE
type
  SQLDMO_DBUSERROLE_TYPE = TOleEnum;
const
  SQLDMORole_db_None = $00000000;
  SQLDMORole_dbcreator = $00000001;
  SQLDMORole_diskadmin = $00000002;
  SQLDMORole_processadmin = $00000004;
  SQLDMORole_securityadmin = $00000008;
  SQLDMORole_serveradmin = $00000010;
  SQLDMORole_setupadmin = $00000020;
  SQLDMORole_sysadmin = $00000040;
  SQLDMORole_db_accessadmin = $00000080;
  SQLDMORole_db_datareader = $00000100;
  SQLDMORole_db_ddladmin = $00000200;
  SQLDMORole_db_denydatareader = $00000400;
  SQLDMORole_db_denydatawriter = $00000800;
  SQLDMORole_db_backupoperator = $00001000;
  SQLDMORole_db_owner = $00002000;
  SQLDMORole_db_securityadmin = $00004000;
  SQLDMORole_db_datawriter = $00008000;
  SQLDMORole_bulkadmin = $00010000;
  SQLDMORole_Unknown = $FFFFFFFF;

// Constants for enum SQLDMO_GROWTH_TYPE
type
  SQLDMO_GROWTH_TYPE = TOleEnum;
const
  SQLDMOGrowth_MB = $00000000;
  SQLDMOGrowth_Percent = $00000001;
  SQLDMOGrowth_Invalid = $00000063;

// Constants for enum SQLDMO_STAT_SCAN_TYPE
type
  SQLDMO_STAT_SCAN_TYPE = TOleEnum;
const
  SQLDMOStatistic_Sample = $00000000;
  SQLDMOStatistic_Percent = $00000001;
  SQLDMOStatistic_Rows = $00000002;
  SQLDMOStatistic_FullScan = $00000003;

// Constants for enum SQLDMO_STAT_AFFECT_TYPE
type
  SQLDMO_STAT_AFFECT_TYPE = TOleEnum;
const
  SQLDMOStatistic_AffectIndex = $00000000;
  SQLDMOStatistic_AffectColumn = $00000001;
  SQLDMOStatistic_AffectAll = $00000002;

// Constants for enum SQLDMO_FULLTEXTSTATUS_TYPE
type
  SQLDMO_FULLTEXTSTATUS_TYPE = TOleEnum;
const
  SQLDMOFullText_Idle = $00000000;
  SQLDMOFullText_CrawlinProgress = $00000001;
  SQLDMOFullText_Paused = $00000002;
  SQLDMOFullText_Throttled = $00000003;
  SQLDMOFullText_Recovering = $00000004;
  SQLDMOFullText_Shutdown = $00000005;
  SQLDMOFullText_Incremental = $00000006;
  SQLDMOFullText_UpdatingIndex = $00000007;
  SQLDMOFullText_DiskFullPause = $00000008;
  SQLDMOFullText_Notifications = $00000009;

// Constants for enum SQLDMO_FULLTEXT_START_TYPE
type
  SQLDMO_FULLTEXT_START_TYPE = TOleEnum;
const
  SQLDMOFullText_Full = $00000000;
  SQLDMOFullText_Inc = $00000001;

// Constants for enum SQLDMO_LINKEDTABLE_TYPE
type
  SQLDMO_LINKEDTABLE_TYPE = TOleEnum;
const
  SQLDMOLinkedTable_Default = $00000000;
  SQLDMOLinkedTable_Alias = $00000001;
  SQLDMOLinkedTable_GlobalTemporary = $00000002;
  SQLDMOLinkedTable_LocalTemporary = $00000003;
  SQLDMOLinkedTable_SystemTable = $00000004;
  SQLDMOLinkedTable_Table = $00000005;
  SQLDMOLinkedTable_View = $00000006;
  SQLDMOLinkedTable_SystemView = $00000007;

// Constants for enum SQLDMO_SQL_VER
type
  SQLDMO_SQL_VER = TOleEnum;
const
  SQLDMOSQLVer_Unknown = $00000000;
  SQLDMOSQLVer_Pre_60 = $00000001;
  SQLDMOSQLVer_60 = $00000002;
  SQLDMOSQLVer_65 = $00000004;
  SQLDMOSQLVer_70 = $00000008;
  SQLDMOSQLVer_80 = $00000010;

// Constants for enum SQLDMO_DBCC_REPAIR_TYPE
type
  SQLDMO_DBCC_REPAIR_TYPE = TOleEnum;
const
  SQLDMORepair_None = $00000000;
  SQLDMORepair_Fast = $00000001;
  SQLDMORepair_Rebuild = $00000002;
  SQLDMORepair_Allow_DataLoss = $00000003;

// Constants for enum SQLDMO_BCP_CODEPAGE_TYPE
type
  SQLDMO_BCP_CODEPAGE_TYPE = TOleEnum;
const
  SQLDMOBCP_RAW = $FFFFFFFF;
  SQLDMOBCP_ACP = $00000000;
  SQLDMOBCP_OEM = $00000001;
  SQLDMOBCP_User = $00000002;

// Constants for enum SQLDMO_SERVERBCP_DATAFILE_TYPE
type
  SQLDMO_SERVERBCP_DATAFILE_TYPE = TOleEnum;
const
  SQLDMOBCPDataFile_Char = $00000001;
  SQLDMOBCPDataFile_Default = $00000001;
  SQLDMOBCPDataFile_Native = $00000002;
  SQLDMOBCPDataFile_WideChar = $00000004;
  SQLDMOBCPDataFile_WideNative = $00000008;

// Constants for enum SQLDMO_COMP_LEVEL_TYPE
type
  SQLDMO_COMP_LEVEL_TYPE = TOleEnum;
const
  SQLDMOCompLevel_Unknown = $00000000;
  SQLDMOCompLevel_60 = $0000003C;
  SQLDMOCompLevel_65 = $00000041;
  SQLDMOCompLevel_70 = $00000046;
  SQLDMOCompLevel_80 = $00000050;

// Constants for enum SQLDMO_SHRINK_TYPE