When SQL Prompt 10.16.6.15646 came out and it claimed to support the SSMS 21 Preview I decided to try it out. I am fully aware that not everything may work as expected. But I was eager to try out SSMS 21 and I'll only use SSMS with SQL Prompt. Anyway, after a day of doing work on a lot of different queries and developing some tsql scripts I closed things down for the day. The next day I powered up SSMS 21 Preview again and realized that I wanted to look at one of my ‘in progress’ tsql scripts that I had worked on the day before. So of course SQL History is the ‘go to’ tool. I discovered that nothing I had worked on the day before was in the history. The only history seemed to be stuff that I would have worked on with my other SSMS install. (V19). So quick test… with SSMS 21 Preview I worked on a query, ran it, edited it, ran it again and then shut down SSMS 21 Preview. Then opened SSMS 21 Preview and I find no history of what I just did. I do the same thing with my other SSMS install (V19) and the query history is present. When I open SSMS 21 Preview I see the query history generated from my SSMS V19 queries. Weird… I generally never never run two different SSMS versions on the same machine (even though you can). Is the SQL Prompt 10.16.6.15646 version not collecting SQL history in the SSMS 21 Preview? Or could it be something else. Alas.. I can't not do without the SQL History tool in SQL Prompt so I'll have to stop using SSMS 21 Preview for now. That's a shame as I love the new Tab management options in SSMS 21 Preview.
When SQL Prompt 10.16.6.15646 came out and it claimed to support the SSMS 21 Preview I decided to try it out. I am fully aware that not everything may work as expected. But I was eager to try out SSMS 21 and I'll only use SSMS with SQL Prompt. Anyway, after a day of doing work on a lot of different queries and developing some tsql scripts I closed things down for the day. The next day I powered up SSMS 21 Preview again and realized that I wanted to look at one of my ‘in progress’ tsql scripts that I had worked on the day before. So of course SQL History is the ‘go to’ tool. I discovered that nothing I had worked on the day before was in the history. The only history seemed to be stuff that I would have worked on with my other SSMS install. (V19). So quick test… with SSMS 21 Preview I worked on a query, ran it, edited it, ran it again and then shut down SSMS 21 Preview. Then opened SSMS 21 Preview and I find no history of what I just did. I do the same thing with my other SSMS install (V19) and the query history is present. When I open SSMS 21 Preview I see the query history generated from my SSMS V19 queries. Weird… I generally never never run two different SSMS versions on the same machine (even though you can). Is the SQL Prompt 10.16.6.15646 version not collecting SQL history in the SSMS 21 Preview? Or could it be something else. Alas.. I can't not do without the SQL History tool in SQL Prompt so I'll have to stop using SSMS 21 Preview for now. That's a shame as I love the new Tab management options in SSMS 21 Preview.