SQL Prompt is 7.2.4.291 (22nd June)

• 
  I just installed SQL Management Studio 2016 and updated my SQL Prompt to 7.2.0.260. SQL Prompt works fine for the snippets and for the SQL built-in functions, but it no longer shows any of the objects in my database or their columns, in either 2012 or 2016.

  Lenka April 26, 2016 21:22

  - 0 +
• 
  Hi Lenka
  
  Sorry to hear you’re having trouble. I haven’t been able to reproduce your issue here so it’d be best if you could contact our support team to investigate it further.
  
  Please enable verbose logging and include the logs in your support request.
  
  Thanks
  Ali

  Ali D April 27, 2016 05:08

  - 0 +
• 
  MSI returned failure code InstallFailure (MSI Error: 1603)

  Kvasi May 26, 2016 05:05

  - 0 +
• 

  Kvasi wrote:

  MSI returned failure code InstallFailure (MSI Error: 1603)

  
  I deleted the config.msi folder and now it works just fine.

  Kvasi May 26, 2016 09:34

  - 0 +
• 

  Open in Excel from the Results grid now exports NULLs as blank cells (UserVoice)

  
  Is there a setting somewhere that can be toggled to adjust this behavior? In my case, I want to export empty cells as "NULL" instead of a blank cell.

  emf411 July 19, 2016 13:53

  - 0 +
• 
  Hi emf411
  
  Currently there's no setting to change the behaviour of NULLs exported to Excel.
  
  The best way to log this would be to create a request on our UserVoice forum. Uservoice helps us track and prioritise our work and you'll get status notifications (along with anyone else that's interested).
  
  Thanks
  Ali

  Ali D July 20, 2016 06:56

  - 0 +
• 
  I just installed 7.2.4.291. (I am running SSMS 2012) I love the feature of the warnings for update/delete sans where clause.
  However I seem to have lost the ability to use "smart rename" (F2). Is there something I am missing?

  siberiaal August 03, 2016 08:51

  - 0 +
• 
  Hi siberiaal,
  
  Using rename/F2 in a script to rename a variable or alias should still work in 7.2.4.
  
  It should be accessible through the right click context menu as well as the shortcut, could you check if right clicking on a variable name and selecting "Rename Variable/Alias" works for you?
  
  Thanks,
  Aaron.

  Aaron L August 04, 2016 06:50

  - 0 +
• 

  Lenka wrote:

  I just installed SQL Management Studio 2016 and updated my SQL Prompt to 7.2.0.260. SQL Prompt works fine for the snippets and for the SQL built-in functions, but it no longer shows any of the objects in my database or their columns, in either 2012 or 2016.

  
  Having the same problem. Sometimes it seems to restart MSSMS and then it works for another 15-20 minutes. Now and then the all suggestions (like ssf) are gone but right now it is "only" my database objects (table names, column names etc).
  
  I even had a strange experience where pressing the ENTER key would paste my text from the clipboad into my script and pressing other keys also behaved oddly. A restart of MSSMS solved that.
  
  Using MSSMS 2012 version 11.0.6020.0
  and SQL Prompt 7.2.4.291

  ofrede August 24, 2016 09:05

  - 0 +
• 
  Hi ofrede,
  
  SQL Prompt only suggesting snippets and built in functions will happen if SQL Prompt hasn't retrieved suggestions from the database. Have you tried refreshing the suggestions (either ctrl+shift+d to refresh just the current database, or disabling/enabling using ctrl+shift+p twice to clear everything) to see if that helps?
  
  Next time it happens could you check your log file to see if there are any errors listed (under SQL Prompt->Help->Show Log).
  
  Thanks,
  Aaron.

  Aaron L August 24, 2016 09:14

  - 0 +

Add comment

Please sign in to leave a comment.