Microsoft KB Archive/289748

= BUG: Missing Values For Database Event Constants =

Article ID: 289748

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q289748



BUG #: 11981 (plato7.x)



SYMPTOMS
SQL Server 2000 Books Online supplies the names of constants used by the Action parameter in the ReportAfter, ReportBefore, ReportError, and ReportProgress events of the Database interface, supported by the Decision Support Objects (DSO) library, but does not supply their values.



CAUSE
The documentation incorrectly assumes that the constants are included as part of an enumeration. The constants, detailed in the &quot;Events&quot; topic in SQL Server 2000 Books Online, are not actually supplied as an enumeration in order to maintain backwards compatibility.



WORKAROUND
You may use the following list of constants and associated values as needed in client applications that reference the DSO library and use the events supported by the Database interface:

Public Const mdactProcess = 1 Public Const mdactMerge = 2 Public Const mdactDelete = 3 Public Const mdactDeleteOldAggregations = 4 Public Const mdactRebuild = 5 Public Const mdactCommit = 6 Public Const mdactRollback = 7 Public Const mdactCreateIndexes = 8 Public Const mdactCreateTable = 9 Public Const mdactInsertInto = 10 Public Const mdactTransaction = 11 Public Const mdactInitialize = 12 Public Const mdactCreateView = 13 Public Const mdactWriteData = 101 Public Const mdactReadData = 102 Public Const mdactAggregate = 103 Public Const mdactExecuteSQL = 104 Public Const mdactNowExecutingSQL = 105 Public Const mdactExecuteModifiedSQL = 106 Public Const mdactConnecting = 107 Public Const mdactRowsAffected = 108 Public Const mdactError = 109 Public Const mdactWriteAggsAndIndexes = 110 Public Const mdactWriteSegment = 111 Public Const mdactDataMiningProgress = 112

Also, the following undocumented constants are used to provide warning information in the ReportError and ReportProgress events:



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0.

Keywords: kbbug kbnofix KB289748

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.