sqlole.h

vc6.0完整版

typedef SQLOLE_HELPID(SQLOLE_XFRSCRIPTMODE_TYPE) enum {
	// How many files the XFR Script is to written to.
	SQLOLEXfrFile_Default = 0x0001,	
	SQLOLEXfrFile_SummaryFiles	= 0x0001,		// One files per class of objects transferred/dropped
	SQLOLEXfrFile_SingleFile	= 0x0002,		// All scripts go to same file
	SQLOLEXfrFile_SingleFilePerObject = 0x0004	// One file per object
} SQLOLE_XFRSCRIPTMODE_TYPE;

typedef SQLOLE_HELPID(SQLOLE_DEPENDENCY_TYPE) enum {
	SQLOLEDep_Parents = 0,						// Default:  return all parents of input object
	SQLOLEDep_FullHierarchy = 0x10000,			// Return full hierarchy; multiple rows of object and parents/children
	SQLOLEDep_OrderDescending = 0x20000,		// Order return in descending order
	SQLOLEDep_Children = 0x40000,				// Return children of input object
	SQLOLEDep_ReturnInputObject = 0x80000,		// Include input object in the return set
	SQLOLEDep_FirstLevelOnly = 0x100000,		// Return only immediate parents/children
	SQLOLEDep_DRIOnly = 0x200000,				// Return DRI dependencies only.
	SQLOLEDep_Valid = 0x3f0000					// All valid options.
} SQLOLE_DEPENDENCY_TYPE;

typedef SQLOLE_HELPID(SQLOLE_OBJSORT_TYPE) enum {
	SQLOLEObjSort_Name = 0,
	SQLOLEObjSort_Type = 1,
	SQLOLEObjSort_Owner = 2,
	SQLOLEObjSort_Date = 3
} SQLOLE_OBJSORT_TYPE;

// May be bitmasked.
typedef SQLOLE_HELPID(SQLOLE_COMPLETION_TYPE) enum {
	SQLOLEComp_Unknown = 0x1000,		// Only bit set
	SQLOLEComp_None = 0x0000,
	SQLOLEComp_Success = 0x0001,
	SQLOLEComp_Failure = 0x0002,
	SQLOLEComp_Always = 0x0003,
	SQLOLEComp_Running = 0x0004,
	SQLOLEComp_Aborted = 0x0008,
	SQLOLEComp_Skipped = 0x0010,
	SQLOLEComp_All = 0x001f
} SQLOLE_COMPLETION_TYPE;

typedef SQLOLE_HELPID(SQLOLE_EVENT_TYPE) enum {
	SQLOLEEvent_Unknown = 0x0000,
	SQLOLEEvent_Info = 0x0001,
	SQLOLEEvent_Warning = 0x0002,
	SQLOLEEvent_Error = 0x0004,
	SQLOLEEvent_AuditSuccess = 0x0008,
	SQLOLEEvent_AuditFailure = 0x0010,
	SQLOLEEvent_All = 0x001f
} SQLOLE_EVENT_TYPE;

typedef SQLOLE_HELPID(SQLOLE_SVCSTATUS_TYPE) enum {
	SQLOLESvc_Unknown = 0,
	SQLOLESvc_Running = 1,
	SQLOLESvc_Paused = 2,
	SQLOLESvc_Stopped = 3,
	SQLOLESvc_Starting = 4,
	SQLOLESvc_Stopping = 5,
	SQLOLESvc_Continuing = 6,
	SQLOLESvc_Pausing = 7
} SQLOLE_SVCSTATUS_TYPE;

typedef SQLOLE_HELPID(SQLOLE_FREQUENCY_TYPE) enum {							// SQLOLE Internal:  sync with qsched.h
	SQLOLEFreq_Unknown = 0x0000,
	SQLOLEFreq_OneTime = 0x0001,
	SQLOLEFreq_OnDemand = 0x0002,
	SQLOLEFreq_Daily = 0x0004,
	SQLOLEFreq_Weekly = 0x0008,
	SQLOLEFreq_Monthly = 0x0010,
	SQLOLEFreq_MonthlyRelative = 0x0020,
	SQLOLEFreq_Autostart = 0x0040,
	SQLOLEFreq_Recurring = 0x007c,		// Any recurring type
	SQLOLEFreq_Valid = 0x007f			// All valid frequency types
} SQLOLE_FREQUENCY_TYPE;

typedef SQLOLE_HELPID(SQLOLE_FREQSUB_TYPE) enum {							// SQLOLE Internal:  sync with qsched.h
	SQLOLEFreqSub_Unknown = 0x0000,
	SQLOLEFreqSub_Once = 0x0001,
	SQLOLEFreqSub_Minute = 0x0004,
	SQLOLEFreqSub_Hour = 0x0008,
	SQLOLEFreqSub_Valid = 0x000d		// All valid frequency subtypes
} SQLOLE_FREQSUB_TYPE;

typedef SQLOLE_HELPID(SQLOLE_FREQRELATIVE_TYPE) enum {						// SQLOLE Internal:  sync with qsched.h
	SQLOLEFreqRel_Unknown = 0x0000,
	SQLOLEFreqRel_First = 0x0001,
	SQLOLEFreqRel_Second = 0x0002,
	SQLOLEFreqRel_Third = 0x0004,
	SQLOLEFreqRel_Fourth = 0x0008,
	SQLOLEFreqRel_Last = 0x0010,
	SQLOLEFreqRel_Valid = 0x001f		// All valid Relative frequencies.
} SQLOLE_FREQRELATIVE_TYPE;

typedef SQLOLE_HELPID(SQLOLE_WEEKDAY_TYPE) enum {							// SQLOLE Internal:  sync with qsched.h
	// Specify for SQLOLEFreq_Weekly; bitmask
	SQLOLEWeek_Unknown = 0x0000,
	SQLOLEWeek_Sunday = 0x0001,
	SQLOLEWeek_Monday = 0x0002,
	SQLOLEWeek_Tuesday = 0x0004,
	SQLOLEWeek_Wednesday = 0x0008,
	SQLOLEWeek_Thursday = 0x0010,
	SQLOLEWeek_Friday = 0x0020,
	SQLOLEWeek_Saturday = 0x0040,
	SQLOLEWeek_WeekDays = 0x003e,		// Monday - Friday
	SQLOLEWeek_WeekEnds = 0x0041,		// Saturday - Sunday
	SQLOLEWeek_EveryDay = 0x007f
} SQLOLE_WEEKDAY_TYPE;

typedef SQLOLE_HELPID(SQLOLE_MONTHDAY_TYPE) enum {							// SQLOLE Internal:  sync with qsched.h
	// Specify for SQLOLEFreq_MonthlyRelative; single-value.
	// This is the relative interval SQLOLE_FREQRELATIVE_TYPE;
	// e.g., on the xth Monday of the month.
	SQLOLEMonth_Unknown = 0,
	SQLOLEMonth_MinValid = 1,
	SQLOLEMonth_Sunday = 1,
	SQLOLEMonth_Monday = 2,
	SQLOLEMonth_Tuesday = 3,
	SQLOLEMonth_Wednesday = 4,
	SQLOLEMonth_Thursday = 5,
	SQLOLEMonth_Friday = 6,
	SQLOLEMonth_Saturday = 7,
	SQLOLEMonth_Day = 8,				// xth day
	SQLOLEMonth_WeekDay = 9,			// xth weekday
	SQLOLEMonth_WeekEndDay = 10,		// xth weekendday
	SQLOLEMonth_MaxValid = 10
} SQLOLE_MONTHDAY_TYPE;

typedef SQLOLE_HELPID(SQLOLE_SRVOPTION_TYPE) enum {
	SQLOLESrvOpt_Unknown = 0x0000,
	SQLOLESrvOpt_RPC = 0x0001,
	SQLOLESrvOpt_Publisher = 0x0002,
	SQLOLESrvOpt_Subscriber = 0x0004,
	SQLOLESrvOpt_Distributor = 0x0008,
	SQLOLESrvOpt_DistPublisher = 0x0010,	// Separate from Publisher and Distributor; dpub bit set
	SQLOLESrvOpt_ODBCDatasource = 0x0020,	// Server is an ODBC datasource
	SQLOLESrvOpt_Valid = 0x003f
} SQLOLE_SRVOPTION_TYPE;

typedef SQLOLE_HELPID(SQLOLE_SUBSCRIBERINFO_TYPE) enum {
	SQLOLESubInfo_SQLServer = 0x00000000,		// Current version of MS SQLServer.
	SQLOLESubInfo_ODBCDatasource = 0x00000001	// ODBC Datasource
} SQLOLE_SUBSCRIBERINFO_TYPE;

typedef SQLOLE_HELPID(SQLOLE_TABLEATT_TYPE) enum {
	// Values from sysobjects.category.
	SQLOLETabAtt_Identity = 	0x0001,		// Table has an identity column
	SQLOLETabAtt_SystemObject =	0x0002,		// Table is a Microsoft system-required object
	SQLOLETabAtt_ForeignKey = 	0x0004, 	// Table has a foreign key
	SQLOLETabAtt_Referenced = 	0x0008,		// Table is referenced by another table's foreign key
	SQLOLETabAtt_Published = 	0x0020,		// Table is published
	SQLOLETabAtt_Replicated =	0x0040,		// Table has an active subscriber
	SQLOLETabAtt_Check = 		0x0080,		// Table has a check constraint
	SQLOLETabAtt_Replica = 		0x0100,		// Table is actively subscribed to a publisher
	SQLOLETabAtt_PrimaryKey = 	0x0200,		// Table has a primary key
	SQLOLETabAtt_Unique = 		0x0400,		// Table has a unique constraint
	SQLOLETabAtt_Default = 		0x0800,		// Table has a DRI default
	SQLOLETabAtt_ReplCheck = 	0x1000,		// Table has a check constraint that excludes replication
	SQLOLETabAtt_HasConstraint =0x1c84		// Table has at least one DRI constraint
} SQLOLE_TABLEATT_TYPE;

typedef SQLOLE_HELPID(SQLOLE_INITIALSYNC_TYPE) enum {
	SQLOLEInitSync_Unknown = 10,     // Pick your favourite invalid number
	SQLOLEInitSync_Min = 0,
	SQLOLEInitSync_BCPNative = 0,
	SQLOLEInitSync_BCPChar = 1,
	SQLOLEInitSync_TableDumpLoad = 2,
	SQLOLEInitSync_Max = 2
} SQLOLE_INITIALSYNC_TYPE;

typedef SQLOLE_HELPID(SQLOLE_REPFREQ_TYPE) enum {
	SQLOLERepFreq_Unknown = 1000,		// Tinyint out-of-range
	SQLOLERepFreq_Min = 0,
	SQLOLERepFreq_Continuous = 0,
	SQLOLERepFreq_Snapshot = 1,
	SQLOLERepFreq_Max = 1
} SQLOLE_REPFREQ_TYPE;

typedef SQLOLE_HELPID(SQLOLE_REPLICATION_TYPE) enum {
	SQLOLERep_Unknown = 0x100, 						// Tinyint out-of-range
	SQLOLERep_LogBased = 0x0001,					// Base for all LogBased replication types.
	SQLOLERep_ManualFilterProc = 0x0002,			// Bit for manually created (not auto-generated) filter proc
	SQLOLERep_LogBasedManualFilterProc = 0x0003,	// Log based, with manually created sync view.
	SQLOLERep_ManualSyncView = 0x0004,				// Bit for manually created (not auto-generated) filter proc.
	SQLOLERep_LogBasedManualSyncView = 0x0005,		// Log based, with manually created filter proc.
	SQLOLERep_LogBasedManualBoth = 0x0007,			// Log based, with manually created sync view and filter proc.
	SQLOLERep_Valid = 7
} SQLOLE_REPLICATION_TYPE;

typedef SQLOLE_HELPID(SQLOLE_SUBSYNC_TYPE) enum {
	SQLOLESubSync_Unknown = 1000,		// Tinyint out-of-range
	SQLOLESubSync_Min = 0,
	SQLOLESubSync_Manual = 0,
	SQLOLESubSync_Auto = 1,
	SQLOLESubSync_Default = 1,			// Auto is default.
	SQLOLESubSync_None = 2,
	SQLOLESubSync_Max = 2
} SQLOLE_SUBSYNC_TYPE;

typedef SQLOLE_HELPID(SQLOLE_PREARTICLE_TYPE) enum {
	// Article pre-creation methods on destination table.
	SQLOLEPreArt_Min = 0,
	SQLOLEPreArt_None = 0,				// Do nothing
	SQLOLEPreArt_DropTable = 1,			// Drop and re-create table
	SQLOLEPreArt_DeleteRows = 2,		// Delete rows (logged)
	SQLOLEPreArt_TruncateTable = 3,		// Truncate table (nonlogged)
	SQLOLEPreArt_Max = 3
} SQLOLE_PREARTICLE_TYPE;

typedef SQLOLE_HELPID(SQLOLE_SUBSTATUS_TYPE) enum {
	SQLOLESubStat_Unknown = 1000,		// Tinyint out-of-range
	SQLOLESubStat_Default = 1000,		// Use default
	SQLOLESubStat_Min = 0,
	SQLOLESubStat_Inactive = 0,
	SQLOLESubStat_Unsynced = 1,
	SQLOLESubStat_Active = 2,
	SQLOLESubStat_Max = 2
} SQLOLE_SUBSTATUS_TYPE;

typedef SQLOLE_HELPID(SQLOLE_RUNPRIORITY_TYPE) enum {
	// These must match the NT ThreadPriority values.
	SQLOLERunPri_Unknown = 100,			// Invalid ThreadPriority
	SQLOLERunPri_Min = 1,
	SQLOLERunPri_Idle = -15,
	SQLOLERunPri_Lowest = -2,
	SQLOLERunPri_BelowNormal = -1,
	SQLOLERunPri_Normal = 0,
	SQLOLERunPri_AboveNormal = 1,
	SQLOLERunPri_Highest = 2,
	SQLOLERunPri_TimeCritical = 15,
} SQLOLE_RUNPRIORITY_TYPE;

typedef SQLOLE_HELPID(SQLOLE_INTSECLOGIN_TYPE) enum {
	SQLOLEIntSecLogin_Unknown = 0,
	SQLOLEIntSecLogin_Min = 1,
	SQLOLEIntSecLogin_Admin = 1,
	SQLOLEIntSecLogin_User = 2,
	SQLOLEIntSecLogin_Replication = 3,
	SQLOLEIntSecLogin_Max = 3
} SQLOLE_INTSECLOGIN_TYPE;

typedef SQLOLE_HELPID(SQLOLE_NOTIFY_TYPE) enum {
	SQLOLENotify_None = 0x0000,
	SQLOLENotify_Email = 0x0001,
	SQLOLENotify_Pager = 0x0002,
	SQLOLENotify_Both = 0x0003,
	SQLOLENotify_Valid = 0x0003
} SQLOLE_NOTIFY_TYPE;

typedef SQLOLE_HELPID(SQLOLE_ENUMNOTIFY_TYPE) enum {
	SQLOLEEnumNotify_Min = 1,
	SQLOLEEnumNotify_All = 1,			// All operators/alerts
	SQLOLEEnumNotify_Actual = 2,		// Only operators/alerts receiving notifications for this alert/operator
	SQLOLEEnumNotify_Target = 3,		// Specifically named target alert/operator(s)
	SQLOLEEnumNotify_Max = 3
} SQLOLE_ENUMNOTIFY_TYPE;

typedef SQLOLE_HELPID(SQLOLE_VERIFYCONN_TYPE) enum {
	SQLOLEConn_LastState = 0x0001,			// State of conn at end of last operation.
	SQLOLEConn_CurrentState = 0x0002,		// Actual current state (checks pipe, etc.)
	SQLOLEConn_ReconnectIfDead = 0x0006,	// Reconnect if we've been disconnected (0x0004 | CurrentState)..
	SQLOLEConn_Valid = 0x0007				// All valid conn operations.
} SQLOLE_VERIFYCONN_TYPE;

typedef SQLOLE_HELPID(SQLOLE_EXEC_TYPE) enum {
	// For ExecuteImmediate, tells how to handle multi-batch commands.
	SQLOLEExec_Default = 0x0000,			// None of the following
	SQLOLEExec_NoCommandTerm = 0x0001,		// No command-terminator parsing (i.e. don't check for "GO"; exec as single batch)
	SQLOLEExec_ContinueOnError = 0x0002,	// Continue batch on all but broken-connection errors.
	SQLOLEExec_NoExec = 0x0004,				// SET NOEXEC ON/OFF
	SQLOLEExec_ParseOnly = 0x0008			// SET PARSEONLY ON/OFF
} SQLOLE_EXEC_TYPE;

typedef SQLOLE_HELPID(SQLOLE_CONFIGVALUE_TYPE) enum {
	SQLOLEConfig_RecoveryInterval = 101,
	SQLOLEConfig_AllowUpdates = 102,
	SQLOLEConfig_UserConnections = 103,
	SQLOLEConfig_Memory = 104,
	SQLOLEConfig_OpenDatabases = 105,
	SQLOLEConfig_Locks = 106,
	SQLOLEConfig_OpenObjects = 107,
	SQLOLEConfig_ProcedureCache = 108,
	SQLOLEConfig_FillFactor = 109,
	SQLOLEConfig_DatabaseSize = 111,
	SQLOLEConfig_MediaRetention = 112,
	SQLOLEConfig_RecoveryFlags = 113,
	SQLOLEConfig_NestedTriggers = 115,
	SQLOLEConfig_RemoteAccess = 117,
	SQLOLEConfig_DefaultLanguage = 124,
	SQLOLEConfig_LanguageInCache = 125,
	SQLOLEConfig_TempdbInRamMB = 501,
	SQLOLEConfig_MaxAsyncIO = 502,
	SQLOLEConfig_MaxWorkerThreads = 503,
	SQLOLEConfig_NetworkPacketSize = 505,
	SQLOLEConfig_RAWorkerThreads = 508,
	SQLOLEConfig_ShowAdvancedOption = 518,
	SQLOLEConfig_LEThresholdPercent = 521,
	SQLOLEConfig_LEThresholdMaximum = 523,
	SQLOLEConfig_BackupThreads = 540,
	SQLOLEConfig_BackupBufferSize = 541,
	SQLOLEConfig_RemoteProcTrans = 542,
	SQLOLEConfig_RemoteConnTimeout = 543,
	SQLOLEConfig_TimeSlice = 1110,
	SQLOLEConfig_RemoteSites = 1119,
	SQLOLEConfig_DefaultSortorderId = 1123,
	SQLOLEConfig_HashBuckets = 1504,
	SQLOLEConfig_SortPages = 1505,
	SQLOLEConfig_MaxLazywriteIO = 1506,
	SQLOLEConfig_RASlotsPerThread = 1509,
	SQLOLEConfig_RAPrefetches = 1510,
	SQLOLEConfig_RADelay = 1511,
	SQLOLEConfig_RACacheMissLimit = 1512,
	SQLOLEConfig_RACacheHitLimit = 1513,
	SQLOLEConfig_SpinCounter = 1514,
	SQLOLEConfig_FreeBuffers = 1515,
	SQLOLEConfig_SMPConcurrency = 1516,
	SQLOLEConfig_PriorityBoost = 1517,
	SQLOLEConfig_RemoteLoginTimeout = 1519,
	SQLOLEConfig_RemoteQueryTimeout = 1520,
	SQLOLEConfig_LEThresholdMinimum = 1522,
	SQLOLEConfig_LogwriteSleepMS = 1530,
	SQLOLEConfig_CursorThreshold = 1531,
	SQLOLEConfig_SetWorkingSetSize = 1532,
	SQLOLEConfig_ResourceTimeout = 1533,
	SQLOLEConfig_UserOptions = 1534,
	SQLOLEConfig_ProcessorAffinityMask = 1535,
	SQLOLEConfig_MaxTextReplSize = 1536
} SQLOLE_CONFIGVALUE_TYPE;

typedef SQLOLE_HELPID(SQLOLE_SRVUSERPROFILE_TYPE) enum {
	// Output from Server.GetUserProfile
	SQLOLESrvUserProf_None = 0x0000,