SQL Scanner hangs when scanning stored procedures with numerous comments (4239682)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SQL Scanner hangs when scanning stored procedures with numerous comments
Description

SQL Scanner hangs when scanning stored procedures with numerous comments
Cause

Product defect
Resolution

WORKAROUND

Exclude the stored procedure from thescanner job. Manually extract the SQL statements from the stored procedure, delete the comments, and send it to the Tuning lab.

STATUS

Waiting for fix in a future release of Quest SQL Optimizer for SQL Server.
Defect ID

ST70181

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title