Microsoft KB Archive/270600

= PRB: Index Tuning Wizard May Not Recommend Indexes for SQL Statements in Triggers =

Article ID: 270600

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q270600



SYMPTOMS
The Index Tuning Wizard may not analyze indexes for SQL statements in triggers.



CAUSE
Only SQL:SQLBatchCompleted events are passed to the Index Tuning Wizard. Trigger statements are logged as SQL:StmtCompleted events and so are not passed to the Index Tuning Wizard.



WORKAROUND
Invoke the Index Tuning Wizard from the Query Analyzer and tune the individual statements in the trigger code.



MORE INFORMATION
For information on the Index Tuning Wizard, see the section &quot;Index Tuning Wizard&quot; in Books Online.

Keywords: kbprb KB270600

-

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

© Microsoft Corporation. All rights reserved.