Index tuning wizard bugs

[DTSFreak]

Hello,

I've the following error when using the index tuning wizard with profiler or analyzer:

"The server returned an error attempting to either create a temporary table or index statistics."

In analyzer tried to tune a given sql statement. On first it did work, but after the second time, i got the above mentioned error.

Also this event occurs in the application eventlog with profiler and the index tuning wizard when tuning a tracefile:

Event Type: Error
Event Source: ITW
Event Category: None
Event ID: 4
Date: 04-05-2006
Time: 08:49:07
User: N/A
Computer: DBA1
Description:
The description for Event ID ( 4 ) in Source ( ITW ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event:
Error in Parsing Event:
SELECT * FROM vw_OpenAppointments.


I'm running sql 2000 enterprise sp3 on the server and running analyzer/profiler from my pc with msde sp4 also installed.

Somebody knows the solution for this?

 

[SajidAttar]

See what Microsoft say about this in More Information section





Regards,


"There are no secrets to success. It is the result of preparation, hard work, and learning from failure." -- Colin Powell

 

[DTSFreak]

Hi,

I've already read that article, but the dbo does own all objects and all objects are reference with the 2-part naming rule