Index tuning wizard bugs
-
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?
-
I have not seen it but it is reproducably every time? Is the process part of a stored procedure where maybe you create a temp table during the run? What is in vw_OpenAppointments?
-
Hi,
I can reproduce it on my pc and server and testserver.
I'm not creating any temp tables, the view vw_openappointments was just a view i was testing. When i reproduce it on the server (sp3) it also gives me that error.
then i installed a whole new fresh copy of sql server without service packs in my vmware (i'm out of machines
) and there it didn't gave me an error.I'm wondering if this is a new sp3 bug?
-
Could be, backup you vmware file and instal SP3. But also make sure what hotfix level you are at becase there was one with a few known issues.
Check out http://www.sqlsecuirty.com and their version database which has a note on the one.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply