How can we help you today? How can we help you today?

Format SQL not working

When I try to use Format SQL via SQL Prompt in SQL Server Management Studio i get the following error message: "SQL prompt encountered problems while processing this script".

What is the cause of this and how do I do to resolve this?
DanielG
0

Comments

3 comments

Sort by
  • DanielG
    The version of SQL Prompt is 8.2.1.2603.

    The error meaasge from the SQL Prompt log shows the following:

    10 Oct 2017 09:05:32,605 [1] WARN RedGate.SQLPrompt.CommonUI.Refactor.RefactoringErrorReporter - Refactoring failed
    System.Exception: Undefined: [ABORT]
    at RedGate.SqlPrompt.Parser.GrammarProcessor.BNFParser.Parse(SqlGrammar outputgrammar)
    at RedGate.SqlPrompt.Parser.SqlGrammar..ctor(ServerVersion serverVersion)
    at RedGate.SqlPrompt.Parser.SqlGrammar.GetGrammar(ServerVersion serverVersion)
    at RedGate.SqlPrompt.ScriptDomInterop.InsertSemicolonsScriptRefactoring.FindSemiColonsForMergeStatements(String script)
    at RedGate.SqlPrompt.ScriptDomInterop.InsertSemicolonsScriptRefactoring.PerformRefactoring(String script, ServerVersion version, ITextReplacer textWriter)
    at RedGate.SqlPrompt.Refactor.ScriptRefactoringAdapter.ApplyRefactoring(IRefactoringDelegate refactorDelegate)
    at RedGate.SqlPrompt.Refactor.RefactorEngine.DoRefactoring(IScriptProvider script, Selection selection, CaretPosition caretPosition, IRefactoringSource refactoringSource, Errors& errors)
    DanielG
    0
  • krzysztofkroczak
    Hi @DanielG,

    We released today version (8.2.2.2657) with the fix of `System.Exception: Undefined: [ABORT]`
    Can you try it?

    Best regards
    Krzysztof
    krzysztofkroczak
    0
  • DanielG
    Hi @krzysztofkroczak ,

    It works perfectly after installing version (8.2.2.2657), thanks! =)

    Best regards,
    Daniel
    DanielG
    0

Add comment

Please sign in to leave a comment.