Features

• Added support for database scoped credentials in Microsoft SQL Server 2016 and later.
• Added support for altering create index statements when using the alter view autocompletion.
• Microsoft Azure Multi-Factor Authentication connections no longer require a second login for SQL Prompt.

Fixes

• Fixed an issue which could cause the Insert Semicolons refactoring step to fail when creating Columnstore indexes.
• Fixed an issue where the live preview does not update when editing styles.
• Fixed an issue which caused Azure Multi-Factor Authentication connections to fail when using secondary Azure AD Tenant.

Features

• When 'Open in Excel' results in the generated Excel file failing to be opened, its location will be opened instead.

Fixes

• Fixed a crash when performing a Smart Rename.
• Fixed an issue where the new update popup was not appearing for some users.

Features

• Added support for CURRENT_TIMEZONE and CURRENT_TIMEZONE_ID when using Microsoft Azure SQL Server.

Fixes

• Fixed an issue which could cause the Insert Semicolons refactoring step to fail when WITH statements are used inside SELECT statements.
• Fixed an issue where SQL Prompt fails to start when the styles folder is set to a file share after an upgrade from a version prior to v10.5.

Fixes

• Fixed an issue which caused legacy custom formatting styles not to be upgraded for some users.

Features

• Enabling verbose logging is now preserved between SSMS sessions.

Fixes

• Fixed an error when upgrading styles from versions prior to SQL Prompt v10.5.
• Fixed a crash when loading styles in a Turkish locale.

Features

• Upgraded styles format to be compatible with the format used in the SQL Prompt ADS extension.

Fixes

• Fixed an issue which could cause SQL Prompt to crash in Visual Studio on startup.