How can we help you today? How can we help you today?

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: Set options in SQL Server Management Studio's SQL Prompt plugin.
martin_daniel
0

Comments

3 comments

Sort by
  • martin_daniel
    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
    martin_daniel
    0
  • martin_daniel
    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
    martin_daniel
    0
  • martin_daniel
    A work around is to make the change in SSMS SQL Prompt, then the setting stick next time Visual Studio is open.
    martin_daniel
    0

Add comment

Please sign in to leave a comment.