Comments
Sort by recent activity
I don't know if it's related, but the act of removing the SqlHistory.db and letting it rebuild had eventual very unexpected consequences. Suddenly "Analysis" was turned on, never had been before. My prompting carefully curated settings are the same, but the behavior of formatting is really messed up. Nothing different today except having removed that file and let it get rebuilt. / comments
I don't know if it's related, but the act of removing the SqlHistory.db and letting it rebuild had eventual very unexpected consequences. Suddenly "Analysis" was turned on, never had been before. M...
Hello, any update you might be able to provide by chance? / comments
Hello, any update you might be able to provide by chance?
@brian_shepard afraid the removal and recreation of the SqlHistory.db file didn't do anything for me. Still takes > 10 seconds to show anything. Good try though!
/ comments
@brian_shepard afraid the removal and recreation of the SqlHistory.db file didn't do anything for me. Still takes > 10 seconds to show anything.Good try though!
@ostandage, as you requested I restarted (machine), opened SSMS and SQL Prompt Tab History and let it sit. Sure enough, after about 10 seconds or less the history shows up. This was different from yesterday when it seemed like no matter how long I let it sit, nothing appeared. I haven't done anything different other than restart. Note the 10 second time frame seems to be consistent - takes at least that long before things appear, which is of course different than the past. Best, --J / comments
@ostandage, as you requested I restarted (machine), opened SSMS and SQL Prompt Tab History and let it sit. Sure enough, after about 10 seconds or less the history shows up. This was different from ...
Same. SSMS 18.12.1 SQL Prompt v10.12.5.30313 / comments
Same.SSMS 18.12.1SQL Prompt v10.12.5.30313
ATurner said:
Hi jsreynolds1 The fix for this has been released in version 10.7.2.22957. This can be downloaded from here https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.7.2.22957.exe
Please can you update to this and let us know if the issue reoccurs?
Can confirm - the problem seems to be gone in the new 10.7.2.22957 release. Thank you, -J / comments
ATurner said:
Hi jsreynolds1The fix for this has been released in version 10.7.2.22957. This can be downloaded from here https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.7...
Can confirm the latest release does fix the problem. Thank you. / comments
Can confirm the latest release does fix the problem. Thank you.
@TomW I upgraded to 18.1.5 and things have been fine so far. Thanks! --J / comments
@TomW I upgraded to 18.1.5 and things have been fine so far. Thanks!--J
I love SQL Prompt and have been using it for years. It's usually extremely reliable. However, a blast through all the procedures seems a bit risky to me. I still find oddities with table variables from time to time, etc. You might want to take it on a case by case basis; maybe convert ten a day or something until they're all completed, testing each one? / comments
I love SQL Prompt and have been using it for years. It's usually extremely reliable.However, a blast through all the procedures seems a bit risky to me. I still find oddities with table variables f...
Hi Tom, I keep trying Azure Data Studio over and over again each few months, but it's simply too unstable in many areas each time I attempt to make it my go-to. I do however find myself using DataGrip more and more, especially as its database product footprint expands. Its sql formatting is pretty darn good, but no-where near as functional as the SQL Prompt product I've been using for years. Has Red-Gate ever considered pursuing an add-in for DataGrip by chance? Best, John / comments
Hi Tom,I keep trying Azure Data Studio over and over again each few months, but it's simply too unstable in many areas each time I attempt to make it my go-to.I do however find myself using DataGri...