Activity overview
Latest activity by martin_daniel
A work around is to make the change in SSMS SQL Prompt, then the setting stick next time Visual Studio is open. / comments
A work around is to make the change in SSMS SQL Prompt, then the setting stick next time Visual Studio is open.
I figured out that it may be related to SQL Prompt sharing the options between SQL Server Management Studio and Visual Studio. The version of SSMS I am running is v18.11.1. SQL Server Management Studio 15.0.18410.0 SQL Server Management Objects (SMO) 16.100.47008.0+9f71e8549924d85d66afcca2b9f45a33061faa1b Microsoft Analysis Services Client Tools 15.0.19750.0 Microsoft Data Access Components (MDAC) 10.0.19041.1 Microsoft MSXML 3.0 6.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.19042 / comments
I figured out that it may be related to SQL Prompt sharing the options between SQL Server Management Studio and Visual Studio. The version of SSMS I am running is v18.11.1.SQL Server Management St...
If it matters, the specific settings I was setting is Apply column alias style Add/remove square brackets Add/remove AS keyword on alias definition for tables and views[image] / comments
If it matters, the specific settings I was setting is Apply column alias styleAdd/remove square bracketsAdd/remove AS keyword on alias definition for tables and views
Visual Studio 2022 SQL Prompt options reset after closing Visual Studio
Closing Visual Studio 2022 Version 17.1.6 causes options to reset for SQL Prompt Version 10.11.11.27632.Saved setting changes to a style do not reset, just ones in the options dialog.Workaround: Se...
@Dan_J Thanks for the update. Once I started noticing the same with some errors I figured it may be a future feature that hadn't been implemented yet. You have a great product with SQL Prompt! / comments
@Dan_J Thanks for the update. Once I started noticing the same with some errors I figured it may be a future feature that hadn't been implemented yet.You have a great product with SQL Prompt!
Here is a screenshot of when SQL Prompt is disabled: [image] / comments
Here is a screenshot of when SQL Prompt is disabled:
@Dan_J , It seems to be any syntax. Here is an example. This code generates the error "Incorrect Syntax near 'GO': SELECT * FROM
GO The second generates a warning "Schema name for procedure is not specified." Se The screenshot show the warning is recognized, but when clicked on it brings up the error list with no warnings. (see image below) SQL Prompt 10.11.9.27382 (Latest Version) Visual Studio 2022 Version 17.1.5 (Current Release) Thank you, Daniel [image] / comments
@Dan_J ,It seems to be any syntax. Here is an example.This code generates the error "Incorrect Syntax near 'GO':SELECT * FROM
GOThe second generates a warning "Schema name for procedure is not sp...