Activity overview
Latest activity by Bev
If you add the style button to the toolbar, select it and then hit Format SQL it will format using that style. If you click a different style on the tool bar and then Format SQL it will use that one. It's a quick way of changing the default style without having to go into the Menu. / comments
If you add the style button to the toolbar, select it and then hit Format SQL it will format using that style. If you click a different style on the tool bar and then Format SQL it will use that on...
Is there a way to limit what's stored in SQL History?
SQL History takes too long to open and freezes SSMS while its doing so, probably due to the size of the db. It also takes forever to search for anything when you get it open. I appreciate the vers...
Adding Format/Styles Buttons To Toolbar
I've created a few different style templates and named them accordingly, but when I want to add them as buttons to quickly change between styles, there is just a list of styles with no label so I d...
rsocol said:
I have the same problem, but the error appears intermittently. If I apply the sugesstion in the previous comment (deleting the SQLHistory.db file), I lose a lot of history. In my case, I had a 80MB SavedTabs.db file last modified on 30 September 2022 and a 200MB SqlHistory.db file last modified today. If I delete the SqlHistory.db and restart SSMS, the file SqlHistory.db is recreated using the data from SavedTabs.db, which is more than one month old. @redgate, please advise.
You're absolutely right, my new SqlHistory.db is over 100mb smaller than the old one, which I hadn't noticed until I couldn't find something that I wanted from the day before. Glad I took a backup! I have emailed redgate again and asked if I can merge them / comments
rsocol said:
I have the same problem, but the error appears intermittently.If I apply the sugesstion in the previous comment (deleting the SQLHistory.db file), I lose a lot of history. In my ...
ETA: I got this from Redgate support and it does appear to have cleared the issue (for the timebeing at least!) Can you try the following
steps:
1 - Close SSMS, Delete the SQLHistory.db file located in %localappdata%\Red
Gate\SQL Prompt 10\
2 - Open SSMS, there should be a tabhistory.migrating file in the app data
folder
3 - Leave SSMS open until the tabhistory.migrating file disappears (this will
take a variable amount of time, depending on how big the existing TH database
is)
Once the tab history.migrating file disappears, you should be able to open the
tab history UI. Same here, multiple times a day now and sometimes multiple times in a row. I had to clear the error 4 times today before I could see in my tab history and search it / comments
ETA: I got this from Redgate support and it does appear to have cleared the issue (for the timebeing at least!)Can you try the following
steps:
1 - Close SSMS, Delete the SQLHistory.db file located...
I'm now getting this issue as well, currently using the most recent version 10.12.2.28458 / comments
I'm now getting this issue as well, currently using the most recent version 10.12.2.28458