Article ID: 319704
Article Last Modified on 5/8/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q319704
BUG #: 102195 (SQLBUG_70)
SYMPTOMS
The Index Tuning Wizard may return an application error if the workload contains a query that performs an inner join between a table and a full-text search function. The following message is displayed in the Application Error dialog box:
Title: wiztrace.exe - Application Error Text: The instruction at "0x41745b63" referenced memory at "0x00000000". The memory could not be "read". Click on OK to terminate the application Click on CANCEL to debug the application
CAUSE
The application error in the Index Tuning Wizard occurs because of an Access Violation in Wiztrace.exe. The application error occurs when Wiztrace.exe tries to reference a memory location that cannot be read. Wiztrace.exe is the executable file for the Index Tuning Wizard.
RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 7.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
301511 INF: How to Obtain the Latest SQL Server 7.0 Service Pack
WORKAROUND
This problem does not occur if you run the Index Tuning Wizard from a computer that is running SQL Server 2000 Client Tools. Therefore, to work around this behavior, run the Index Tuning Wizard from a workstation that is running SQL Server 2000 Client Tools, and then connect to the computer that is running SQL Server 7.0.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft SQL Server 7.0 Service Pack 4.
MORE INFORMATION
If Dr. Watson is configured to be your default application debugger, you may not see the error and the Index Tuning Wizard closes. However, the error is reported to the Application Event Log with the following Dr. Watson Informational event:
EventID: 4097 Source: DrWatson Category: None Text: The application, , generated an application error The error occurred on 'date' @ 'time' The exception generated was c0000005 at address 41745B63 (<nosymbols>)
Additional query words: Full-Text AV FTS
Keywords: kbbug kbfix kbsqlserv700presp4fix KB319704