Features

• SQL Prompt Pro - Added support for Microsoft SQL Server Management Studio (SSMS) 19 Preview.

Fixes

• SQL Prompt Pro - Fixed an issue when applying autofixes in bulk.
• SQL Prompt Pro - Fixed an issue where try_convert formatting could cause an error.
• SQL Prompt Pro - Fixed an issue where Qualify Object Names would incorrectly qualify with synonyms from other schemas.
• SQL Prompt Pro - Fixed an issue when auto completing INSERT INTO statements for tables in a different database to the current connection.

Fixes

• SQL...

Features

• SQL Prompt Pro - Improved detection when Replace Select Into With Create Table autofix is available.
• SQL Prompt Pro - Added the ability to open SQL Dependency Tracker from the object definition window when viewing an object's dependencies. (SQL Toolbelt Essentials subscription license required).
• SQL Prompt Pro - Added suggestions for existing resource pools for ALTER and DROP statements.

Fixes

• Fixed an error with the autofix for Add Columns To Insert...

Features

• SQL Prompt Pro - Added "no-layout" option to command line formatter.
• SQL Prompt Pro - Improved suggestions for CREATE TABLE.

Fixes

• Fixed an issue where 'Restore defaults' in the options menu could require multiple attempts to restore default settings.
• Resolved issue with the Bulk Formatter.
• Fixed an issue where SQL Prompt in Visual Studio 2022 may crash when importing and exporting settings.
• Fixed an issue where Smart Rename would crash when using the...

Features

• Internal changes.

Features

• SQL Prompt Pro - Added support for DEFAULT_DOMAIN function.

Fixes

• Fixed a crash with Find Invalid Objects when a cached database is no longer available.

Features

• Internal changes.

Fixes

• Fixed a crash when opening tab history.

Features

• SQL Prompt Pro - Added the ability to share formatting...

Fixes

• Fixed a crash when showing the object definition window for table aliases.

Features

• SQL Prompt Pro - Added a Bulk Format all open tabs option in the Microsoft SSMS Bulk Actions menu. (SQL Toolbelt or SQL Toolbelt Essentials license required)
• SQL Prompt Pro - Added support for DATEPART function arguments TZOFFSET and ISO_WEEK.

Fixes

• Fixed a display bug with some tooltips.
• Fixed a crash when showing the object definition...

Features

• SQL Prompt Pro - Added the ability to duplicate a tab in Microsoft SQL Server Management Studio (SSMS).

Features

• Changed the way objects are qualified such that the default schema is chosen where multiple schemas match.

Fixes

• Fixed the crash when using summarize scripts where the script is invalid.

Fixes

• Fixed an issue where connections to multiple contained Azure SQL databases may...

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...

Features

• SQL Prompt Pro - General performance improvements.

Fixes

• Fixed Smart Rename and Split Table for connections using TrustServerCertificate.

Fixes

• Fixed a crash on startup in Microsoft Visual Studio.

Features

• Added support for Smart Rename and Split Table for Microsoft Azure MFA connections.

Fixes

• Fixed script being misinterpreted when AT TIME ZONE was used with a variable...

Fixes

• Fixed an issue where the template parameters window appears after auto-completing a snippet containing XML.
• Fixed an issue where the refactor insert into update operation failed when using certain SQL scripts.

Fixes

• Internal improvements on SQL Prompt Tab History functionality.

Fixes

• Fix for crash on startup when using extensions with conflicting versions of the Serilog logging library.