Home > IT Answers > Database > Index Tuning Wizard shows error occurred while executing SQL statement but I can’t find the problem
SQL Server Ask the Experts
2,585 pts.
 Index Tuning Wizard shows error occurred while executing SQL statement but I can’t find the problem
Index Performance, Index Tuning Wizard, ITW, SQL, SQL Server errors, SQL Server performance tuning
I am facing a strange problem while using the Index Tuning Wizard (ITW) in SQL Server 2000. It shows error occurred while executing a SQL statement. I've checked every thing like trace is okay, as they show no problem with SQL Server 2005. Kindly give me some solution, URGENT.

Software/Hardware used:
ASKED: May 14, 2008  3:36 AM
UPDATED: September 28, 2008  5:39 AM
RELATED QUESTIONS
Answer Wiki:
I would recommend using the SQL 2005 tuning wizard as the SQL 2005 tuning wizard is better than the SQL 2000 tuning wizard.
Last Wiki Answer Submitted:  September 28, 2008  5:39 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Does this faulting procedure provide more error description?
Did you try and rerun the statement manually and see where it stops?

alessandro.panzetta
 9,680 pts.
 

Did you create the trace file with the SQL 2005 profiler, or the SQL 2000 profiler? Is the target system SQL 2000 or SQL 2005?

Denny Cherry
 64,520 pts.