Sql Prompt Intellisense causes Sql Management Studio failure

• 
  Same SQL Prompt version, same SSMS version. For me, the error does not occur immediately upon typing "@" though, but after selecting a table variable from the SQL prompt suggestions box.
  E.g.
  

  1. Type "INSERT INTO @"
  2. Select @tvp from the suggestions
  3. Crash

  SupiluliumaII June 16, 2021 15:26

  - 0 +
• 
  Hi @lansmank , @SupiluliumaII
  
  Thanks for getting in touch with us. We've been able to recreate the issue and will be releasing a fix for this tomorrow.

  NathWilson June 16, 2021 15:45

  - 0 +
• 
  I have the same issue but ssms crashing when trying to write any function like 'left'. How can I get the previous version of sql prompt ?

  DanRey June 16, 2021 16:09

  - 0 +
• 
  Thanks Nath!!  I appreciate the quick response from your team!

  lansmank June 16, 2021 16:21

  - 0 +
• 
  @DanRey You can download the previous version from here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.6.14.20978.exe
  

  AdrianB June 16, 2021 16:26

  - 0 +
• 
  Thank you Adrian!!, now is working fine, it's very helpful that link

  DanRey June 16, 2021 16:34

  - 0 +
• 
  same version as above and same issues as above.  SSMS crashing left and right, latest was when I used the LAG function it crashed.  Based on 3 releases in the past 9 days, and another coming tomorrow it sounds like, things are looking pretty sloppy.

  jgonnering June 16, 2021 18:02

  - 0 +
• 
  Thanks for this, all, It has been a frustrating day!

  carlb June 16, 2021 18:03

  - 0 +
• 
  Thank you for the link for the previous version.     Here was mine:  
  
  Same SQL Prompt Version - SSMS v15.0.18384.     Worked fine until I tried to select a reserved word from the drop down.   SSMS crashes with this error:   
  
  

  <div>2021-06-16 14:37:50.253 -04:00 [Debug] Inserted text : c</div><div>2021-06-16 14:37:50.721 -04:00 [Information] [10301] Run 'Matching object names' completion handler!</div><div>2021-06-16 14:37:50.914 -04:00 [Information] [10340] Run 'Code analysis task <SQLQuery2.sql*>' completion handler!</div><div>2021-06-16 14:37:55.765 -04:00 [Error] LogService caught unhandled exception in AppDomain: 'Object reference not set to an instance of an object.'</div><div>System.NullReferenceException: Object reference not set to an instance of an object.</div><div>&nbsp; &nbsp;at RedGate.SQLPrompt.CommonUI.Forms.SchemaInformation.ObjectDefinitionBox._candidateName_Paint(Object sender, PaintEventArgs e)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.OnPaint(PaintEventArgs e)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.WmPaint(Message& m)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.WndProc(Message& m)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)</div><div>&nbsp; &nbsp;at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)</div><div>2021-06-16 14:37:55.771 -04:00 [Error] Report error dialog UI shown</div><div>System.NullReferenceException: Object reference not set to an instance of an object.</div><div>&nbsp; &nbsp;at RedGate.SQLPrompt.CommonUI.Forms.SchemaInformation.ObjectDefinitionBox._candidateName_Paint(Object sender, PaintEventArgs e)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.OnPaint(PaintEventArgs e)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.WmPaint(Message& m)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.WndProc(Message& m)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)</div><div>&nbsp; &nbsp;at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)</div><div>&nbsp; &nbsp;at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)</div>

  SBuckVRT June 16, 2021 18:55

  - 0 +
• 
  Adding my issue just for documentation.   Thank you for the link to the previous version.   
  
  

  SSMS v15.0.18384   SQL Prompt 10.6.15.21056

  Using any Reserved word from the Drop Down list causes SSMS to crash and the following error: 

  
  

  2021-06-16 14:37:50.253 -04:00 [Debug] Inserted text : c

  2021-06-16 14:37:50.721 -04:00 [Information] [10301] Run 'Matching object names' completion handler!

  2021-06-16 14:37:50.914 -04:00 [Information] [10340] Run 'Code analysis task <SQLQuery2.sql*>' completion handler!

  2021-06-16 14:37:55.765 -04:00 [Error] LogService caught unhandled exception in AppDomain: 'Object reference not set to an instance of an object.'

  System.NullReferenceException: Object reference not set to an instance of an object.

     at RedGate.SQLPrompt.CommonUI.Forms.SchemaInformation.ObjectDefinitionBox._candidateName_Paint(Object sender, PaintEventArgs e)

     at System.Windows.Forms.Control.OnPaint(PaintEventArgs e)

     at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)

     at System.Windows.Forms.Control.WmPaint(Message& m)

     at System.Windows.Forms.Control.WndProc(Message& m)

     at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

     at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

     at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

  SBuckVRT June 16, 2021 19:02

  - 0 +
• 
  Same SQL Prompt and SSMS versions.
  

  My issues are typing RAND() and CONVERT().
  

  noob2016 June 16, 2021 19:53

  - 0 +
• 
  We released a fix for this today in SQL Prompt v10.6.16.

  NathWilson June 17, 2021 14:16

  - 0 +
• 
  Thank you Nath.
  I checked this morning and saw the release build, have applied it and it seems to have corrected the issue.
  I appreciate the quick turnaround on this!!

  lansmank June 17, 2021 14:25

  - 0 +
• 
  I have applied and the issues I had with reserved words has been corrected.  Thank you!

  SBuckVRT June 17, 2021 14:59

  - 0 +
• 
  NathWilson said:

  We released a fix for this today in SQL Prompt v10.6.16.

  Thanks for the fix, works for me too! 🙂

  SupiluliumaII June 17, 2021 15:06

  - 0 +

Add comment

Please sign in to leave a comment.