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

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,319 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.