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

SQL Prompt freezes Query Analyzer and SSMS

On typing certain words or pasting(Ctrl+V) those words in query analyzer while SQL Prompt is active freezes query analyzer. You have to crash out and restart query analyzer to continue working.
sangha
0

Comments

5 comments

  • sangha
    I also tried this in SQL Server Management Studio. The same thing happens there too.
    sangha
    0
  • sangha
    After waiting for a few minutes I got the following unhandled exception:-
    Unhandled exception has occured in you application.

    Exception of type 'System.OutOfMemoryExceptopn'

    ************** Exception Text **************
    System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
    at RedGate.SQLCompare.ASTParser.StructureParser.statement()
    at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch()
    at RedGate.SQLCompare.ASTParser.StructureParser.expr()
    at _43._1()
    at _43.SetSqlScriptProvider(IScriptProvider provider, CaretPosition caretPosition)
    at RedGate.SqlPrompt.Engine.SqlPromptEngine.SetSqlScriptProvider(IScriptProvider provider, CaretPosition caretPosition)
    at _5._1(Object , CaretPositionEventArgs )
    at _3._1(Object , CaretPositionEventArgs )
    at _4.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    sangha
    0
  • Tilman
    Hi,

    Thanks for posting. Could you tell me what those words are?

    Regards,

    Tilman
    Tilman
    0
  • sangha
    You can copy and paste the following words or type them
    process and send
    
    SSMS and Query Analyzer will also stop responding.
    sangha
    0
  • Tilman
    Hi,

    That's great, I am able to reproduce it. Good spot!

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.