Microsoft KB Archive/319704

= FIX: Application Error May Occur in Index Tuning Wizard with a Query That Uses Full Text Search Functions =

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 &quot;0x41745b63&quot; referenced memory at &quot;0x00000000&quot;. The memory could not be &quot;read&quot;. 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

Additional query words: Full-Text AV FTS

Keywords: kbbug kbfix kbsqlserv700presp4fix KB319704

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.