Script freezes SQL Refactor Summarize Script

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

Script freezes SQL Refactor Summarize Script

Postby RichardRayJH » Wed Nov 25, 2009 7:47 pm

In both SSMS 2005 and SSMS 2008 I have a sp that freezes SQL Refactor in its tracks and requires that I crash out of SSMS to get back to work. The Refactor progress dialog stops at 99% and stays there forever (or at least 30 minutes, which as long as I've been willing to wait).

Is there a known problem? The script is a bit over 400 lines long? Is there a size limitation? I can send the script along for review if that would help...
-
Richard Ray
Jackson Hole Mountain Resort
Teton Village, WY
RichardRayJH
 
Posts: 13
Joined: Mon Sep 21, 2009 9:49 pm
Location: Teton Village, WY, USA

Postby Anu Deshpande » Fri Nov 27, 2009 9:42 am

Many thanks for your post Richard.

Can you kindly let me know the detailed version of SQL Refactor?

You can know the detailed version of SQL Refactor by navigating to SQL Refactor --> About SQL Refactor and version number is displayed on bottom right (just above Close button.)
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests