On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

SQL Prompt hangs if the query is very large to format the Query

sammysungsammysung Posts: 3 New member
SQL Prompt hangs if the query is very large  to format the Query , It has 1000+ lines of code. 

Answers

  • Jessica RJessica R Posts: 1,315 Rose Gold 4
    Hi @sammysung

    Thanks for your post! I believe we have a ticket open with you on this. As mentioned there, I'm afraid the particular example file you shared is quite large and we aren't able to support formatting a file of this size.
    Note ,however, that SQL Prompt will complete formatting it eventually but will take hours (I had left it running overnight and it did complete).

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.