Index Tuning Wizard Errors

I have read somewhere in the past the Index Tuning Wizard has a problem when
trying to read tables that have Single Quotes in data returned. Is this true
in your case? Perhaps just running the procedure and reading the client and
execution plan will give you a good start on where to place your indexes.

--
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/


"Robbie" wrote in message
news:d8d0e6c5-0b26-4bb5-89d2-cdd88c1d2528@t1g2000pra.googlegroups.com...
> Hello,
>
> I'm trying to use the Index Tuning Wizard to figure out how to
> optimize a complicated stored procedure. I've run the SP and took a
> trace of it, and then try running IT Wiz on the trace file, but keep
> getting the following error:
> An error occurred trying to execute a SQL statement.
>
> The SP runs just fine so I don't think there are any errors in the
> script. Any ideas of what's wrong? Are there service patches we need
> for Enterprise Manager or Query Analyzer?
>
> We're using MS-SQL Server 2000, SP3.
>
> Thank you,
> Robbie