Issue: SQL Prompt Queries > History > Restore open queries

• 
  I have been seen this same behavior.  Appears to have happened in the last several weeks or more.

  AdamGojdas November 20, 2024 17:43

  - 0 +
• 
  Additionally I have the issue where I have SSMS open with many open tabs. I can close all of the tabs. I close SSMS and then open SSMS again and it recovers all the previously closed tabs and makes duplicates for certain ones.  Why is it continuously opening tabs that have now been closed?

  AdamGojdas November 20, 2024 17:59

  - 0 +
• 
  @jsreynolds1 & @AdamGojdas
  
  Thanks for reaching out to Redgate Support. Fortunately, the behavior you are describing is a known behavior already under investigation by the development team. As soon as they release some remediation steps or a patch fix for this issue I will circle back here and update you further.
  
  You can also keep an eye on the https://download.red-gate.com/checkforupdates/SQLPrompt/ for any subsequent releases.

  cperez November 20, 2024 20:05

  - 0 +
• 
  @cperez
  
  One additional odd behavior.  For the SQL code I work on we have all our sql objects, procs, views, functions, etc in source code files and work from them.  We keep them in version control and apply the code from the source file to the DB for changes. When opening a source code file while having several others in tabs in SSMS open I have twice had the data overwritten in the newly open file from another file I had open. This behavior I have only seen in the last day but I was thinking it was related to the SQL Prompt re-opening feature.  I have never experienced this before this week which was when I updated SQL Prompt.  Not sure of what the details are to have caused it but I at least know it has occurred to make sure I don't save code from one file into another.  Luckily our code is in version control so it is easy for me to identify the whole file changed but not something I am thrilled with occurring.

  AdamGojdas November 20, 2024 20:45

  - 0 +
• 
  @jsreynolds1 Root Cause has been identified for this behavior and is currently being worked on for a fix. Will have more for you likely sometime next week.

  cperez November 22, 2024 20:11

  - 0 +
• 
  @jsreynolds1
  How can I disable the behavior in the meantime?

  Jaragoth November 22, 2024 22:35

  - 0 +
• 
  @Jaragoth , @AdamGojdas , @jsreynolds1
  
  Thanks all for your patience on this issue.
  
  Please upgrade Prompt to the latest version of 10.15.3 as this issue has been remediated in that version. 
  
  https://download.red-gate.com/checkforupdates/SQLPrompt/
  
  Cheers,
  
  Christian Perez
  
  

  cperez November 26, 2024 15:17

  - 0 +
• 
  Is this issues resolved? i think it is still happening with 10.15.3.12768
  

  Alexisonfire December 03, 2024 07:25

  - 0 +
• 
  Still happening for me too

  DavidB147 December 05, 2024 08:15

  - 0 +
• 
  if you are ok to loose all history, you may tinker around in %userprofile%\appdata\Local\Red Gate\SQL Prompt 10\. 
  Deleting SqlHistory.db removed all my history but restored functionaltity. 
  
  

  Alexisonfire December 11, 2024 07:17

  - 0 +

Add comment

Please sign in to leave a comment.