Activity overview
Latest activity by Thom_A
I, like others here, am quite disappointed that this is still a problem. The matter was reported at the start of August and we're now almost at the end of October; almost 3 full months have passed. Data Typing is such a fundamental part of working with data (I hope we all know how bad/foolish it is to store numerical data in a varchar here) so the fact that numerical data is being converted to a string in this process and yet to be fixed is a huge fundamental breaking change. / comments
I, like others here, am quite disappointed that this is still a problem. The matter was reported at the start of August and we're now almost at the end of October; almost 3 full months have passed....
Can't access Remote Server Shares in Restore Dialogue
Hi,I am adding a new Instance to SQL Backup, and trying to restore a database on the instance, however, SQL Backup reports "Cannot access resource. Check that you have the correct permissions to v...
Hi Dan, After several uninstalls, a downgrade of SQL prompt, a restart, upgrade, another restart, I got things to work. For note, however, I am using the latest version of SSMS, 18.9.1
/ comments
Hi Dan,After several uninstalls, a downgrade of SQL prompt, a restart, upgrade, another restart, I got things to work.For note, however, I am using the latest version of SSMS, 18.9.1
Updating to 10.6.12.20269 broken SSMS Queries
I've just updated to Prompt 10.6.12.20269 and I now can't use SSMS. Creating a new Query window asks for me to confirm the encoding (I have never seen this before) as below:
Regardless of the opt...
Thanks Alex. It was set to "Remove", however, I changed the option to Add, saved, and then changed it back and it fixed the problem. Guessing there was a setting error somewhere and rewriting the settings fixed it. Thanks.
/ comments
Thanks Alex. It was set to "Remove", however, I changed the option to Add, saved, and then changed it back and it fixed the problem. Guessing there was a setting error somewhere and rewriting the s...
Hi @Alex B I don't make use of the Aliases page in the SQL Prompt Options:
[image]
/ comments
Hi @Alex B I don't make use of the Aliases page in the SQL Prompt Options:
Format SQL has started adding AS prior table object aliases
Previously, SQL Prompt preserved the the omission of `AS` on object aliases, however, as of this morning it has started adding it. As a simple example If I had the SQL below:
SELECT MT.MyColumn AS ...