Home > IT Answers > SQL Server > Index Tuning Wizard shows error occurred whil...
Help

Question

  Asked: May 14 2008   3:36 AM GMT
  Asked by: SQL Server Ask the Experts

Index Tuning Wizard shows error occurred while executing SQL statement but I can't find the problem


SQL Server performance tuning, Index Performance, SQL, SQL Server errors, ITW, Index Tuning Wizard

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

CREATE ANSWER
View History
Start this Answer and Earn your Knowledge Points!

By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.

Browse more Questions and Answers on SQL Server, Database and Development.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Alessandro.panzetta  |   May 21 2008  9:27AM GMT

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

 

Mrdenny  |   May 31 2008  9:48PM GMT

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?