Microsoft KB Archive/272439

= PRB: SQL 2000 Profiler Doesn't Capture SHOWPLAN Events if the BinaryData Data Column Is Not Captured =

Article ID: 272439

Article Last Modified on 3/18/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q272439



SYMPTOMS
When using the SQL Server 2000 Profiler to capture the SHOWPLAN event classes from the Performance event category, if the BinaryData data column is not captured, these events are captured but with no data in them.



WORKAROUND
Select the BinaryData data column in the profiler trace to ensure that these events are captured with the correct data.



MORE INFORMATION
The following event classes from the Performance event category are dependent on the BinaryData data column:
 * Show Plan All: Displays the query plan with full compile-time details (for example, costing estimates and column lists) of the SQL statement being executed.
 * Show Plan Statistics: Displays the query plan with full run-time details (including actual number of rows passing through each operation) of the SQL statement that was executed.
 * Show Plan Text: Displays the query plan tree of the SQL statement being executed.

Keywords: kbprb kbpending KB272439

-

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

© Microsoft Corporation. All rights reserved.