Activity overview
Latest activity by Dave Pendleton
Another syntax error introduced by reformatting: [image] / comments
Another syntax error introduced by reformatting:
I have also tried this using a local SQL Server instance, version 16.0.4085.2 I have all the Microsoft Learn example code in one script, when I format using my options, the following error(s) are introduced into a previously error-free script: [image] [image] [image] My options are: [image] / comments
I have also tried this using a local SQL Server instance, version 16.0.4085.2I have all the Microsoft Learn example code in one script, when I format using my options, the following error(s) are in...
SQL Graph Support
It appears that SQL Prompt still does not completely support SQL Graph databases in SQL Server 2022 or Azure SQL Database:Format SQL does not work correctly, or at all.Add Square Brackets brackets ...
Copy As IN Clause Duplicates
I swear I remember that the "Copy As IN Clause" option in a grid removed duplicates. However now when I use it, duplicates are included. Is this correct?SMSS 19.1SQL Prompt 10.13.16.3650
ADU with MFA Crashes SQL Compare
I have two projects that compare Azure SQL database instances to one another. Both projects use Active Directory universal with MFA authentication.95% of the time, when I initiate a compare, the cr...
No Visual Studio 2022 Extension
I recently installed Visual Studio 2022. I uninstalled SQL Prompt, then reinstalled; the SP extension does not appear in the new VS 2022 instance. My previous VS 2019 instance is still installed.Is...
Suggestions stop working with STRING_SPLIT
When CROSS APPLY STRING_SPLIT(...) is used in a query, suggestions stop working.
SQL Prompt is bracketing the TRIM function in Visual Studio 2019
Prompt version 10.13.7.360Visual Studio 18.12.1This does not happen in SQL Server Management Studio.
Changing font of script preview popup
When I hover the cursor over a table name in SSMS then click the tooltip to display its script, the font has changed to Courier New. How is this changed back to my previous font? I've checked both ...
What happened to square brackets?
Qualifying identifiers with square brackets has been broken for at least three releases now.My current build is 10.12.6.30951. Square brackets are no longer added with using 'Format' or Ctrl-K, Y, ...