SQL Object - SQL Prompt Pro

Release Notes: Updates in 5.0 Find Invalid Objects SQL Prompt 5 enables you to easily find invalid objects in your database. This can be useful, for example, if you have inherited a legacy database and you want ... to know if objects are referencing other objects that no longer exist in the database. Script Object as ALTER from a query window If you are navigating a query that contains a reference to an object, SQL ... Prompt 5 enables you to script out that object directly from the query window by pressing F12. View column dependencies SQL Prompt 5 enables you to view a list of objects that reference a column. SQL ...

Release Notes: Updates in 4.0 Enhanced user interface The user interface for intellisense suggestions and object definitions has been redesigned to be less intrusive and to make SQL Prompt's features more ... for SQL 2000, SQL 2005 and SQL 2008 SQL server editions. Suggestions are more accurate and reliable, and cover a more extensive scope of T-SQL. Performance improvements SQL Prompt 4 caches database objects ... your preferred formatting to code. Temporary storage only of database objects on disk Database objects are only cached during your current session. When closing down your query editor, the SQL Prompt ...

Description: Intelligent code completion and layout for MS SQL Server. SQL Prompt automates the retrieval of database object names, syntax, and snippets as you write, intelligently offering only appropriate code ... Table/View/Column/Sproc name completion Layout makes scripts easy to read JOIN/JOIN ON syntax completion Expand wildcard to column names list Object creation-SQL viewing pane Mouse-over tool tips that give object ... definitions including a useful summary Parameter hinting for user-defined functions Cross-database queries Distributed queries with linked SQL Server instances Scripted objects included in candidate list ...

Release Notes: and databases. Qualify Object Names no longer unqualifies parameters of rowset functions. EI028 no longer fires on IDENTITY columns. Format SQL no longer throws an error when trying to format TRIM statements ... Filter the suggestions that SQL Prompt shows by schemas, in addition to servers and databases. You can now filter the suggestions that SQL Prompt shows by schemas, in addition to servers ...

Release Notes: Fixed an issue which would cause the Qualify Object Names refactoring to sometimes generate incorrect SQL when used on an UPDATE statement. SP-7825: Fixed keyboard shortcut_(Ctrl+Shift+E)_ for the [code ... Smart Rename and Split Table refactorings are now no longer supported for SQL Server 2000/2005. SP-7804: Fixed an issue with suggesting synonyms when schema/database filtering is enabled. SP-7824: ... analysis issue details pane](https://documentation.red-gate.com/sp9/sql-code-analysis/inspecting-issues). ...

Release Notes: License Required). Added a SQL Dependency Tracker integration to show Used/Used By dependency view in the object definition window. (SQL Toolbelt or SQL Toolbelt Essentials License Required). ... v10.7.3.32021 Updated Sep 9, 2021 Fixes Fixed a crash when showing the object definition window for table aliases. v10.7.2.22957 Updated Sep 7, 2021 Features Added a Bulk Format to all open tabs ... option in the Microsoft SSMS Bulk Actions menu. (SQL Toolbelt or SQL Toolbelt Essentials license required) Added support for DATEPART function arguments TZOFFSET and ISO_WEEK. Fixes Fixed a display bug ...

Release Notes: v10.10.4.26165 Updated Jan 18, 2022 Features Improved detection when Replace Select Into With Create Table autofix is available. 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). Added suggestions for existing resource pools for ALTER and DROP statements. Fixes Fixed ... window. v10.10.2.25539 Updated Dec 9, 2021 Fixes Fixed an issue where partition schemes would not show in the script preview for Azure SQL Database. Fixed a crash that could occur in the tab history window. ...

Release Notes: Updates in 9.5.11 Fixed an issue with incorrect handling of case sensitivity in Inline EXEC refactoring. SP-7713: SQL Prompt execution warnings no longer trim the beginning of object names in some ...

Release Notes: only for the current session. It can be disabled on the Suggestions > Behavior page, under Show code suggestions. Added the ability to download the installer instead of running it when SQL Prompt ... informs that there is a new version available. SP-7558: Find Invalid Objects now reports triggers that are on non-existent tables. ...

Release Notes: Updates in 6.1 Server/database connection filtering. You can now specify the databases you want SQL Prompt to load suggestions for. Synonyms (including columns from a synonym’s base object) are now ... suggested. CLR functions and CLR stored procedures are now suggested. XML functions are now suggested and fully supported. SQL Azure databases are now supported. Keep a history of query tabs you open in SQL ... Server Management Studio. You can now share snippets with other SQL Prompt users by using a shared snippets folder. ...

Release Notes: Add refactoring for converting sp_executesql expressions to SQL. Added formatting for EXTERNAL TABLE, EXTERNAL DATA SOURCE, EXTERNAL FILE FORMAT. Added formatting for WINDOW clause. Fixed an issue ... where casing wouldn't be applied to a built-in function after cross applying a statement with a user defined XML function. Fixed an issue where "Qualify Object Names" would add incorrect ...

Release Notes: an INSERT statement Open results in Excel Highlight matching objects- When you place the caret on an object in a script, SQL Prompt now highlights all usages of that object. Suggestions improvements SQL ... Prompt now offers suggestions for the following SQL Server 2016 syntax: Row-level security (MSDN) Dynamic data masking (MSDN) Always encrypted (MSDN) Stretch tables (MSDN) System versioning (MSDN) Query ... are also now suggested in more statements. Tab history improvements You can now disable tab history Tab history now includes a Closed tab: If you launch Management Studio by opening a script from SQL ...

Release Notes: Adds a 'Show all issues` link to the autofix popup window. Added a `Show all issues` link to the autofix popup window. Fixed an issue which was preventing SQL Prompt from launching when ... upgrading from a previous version. Fixed an issue which would sometimes cause unwanted newlines to be inserted into scripts generated from `Script Object as ALTER`. Fixed an issue which caused the `Smart ... Rename`, `Encapsulate Object as Stored Procedure` and `Split Table` features to not work for some users. ...

Release Notes: May 11, 2020 Features NOTE: The keyboard shortcut for "Show Open Tabs" has been changed from Ctrl+Q to Ctrl+Shift+X. Fixes SP-7985: SQL Prompt no longer attempt to qualify objects when ... in the Tab History window using the F2 keyboard shortcut. The object definition window now remembers its size across SQL Server Management Studio sessions. Added support for SQL Server 2019 syntax ... they are already qualified. Fixed an error where running inline exec on certain procedures would change behaviour. Fixed an error where SQL Prompt would fail to parse certain QUERY_STORE options. Fixed an error ...

Release Notes: for the following Microsoft SQL Server 2022 functions: GENERATE_SERIES. JSON_PATH_EXISTS. JSON_OBJECT. JSON_ARRAY. GREATEST. Adjusted 'FindInvalidObjects' combobox dropdown width. Added the ability to close ... cultures. Fixed an issue where uppercase was applied to columns from OPENJSON when formatting SQL query. Fixed an issue where Qualify Object Name feature replaced wrong parts of the script. Fixed an issue ... 2023 Fixes Fixed style override when saving SQL Prompt settings. Fixed an issue with SQL History ignoring numbers in search. Fixed an issue where single line comments were not properly formatted. Fixed ...

Release Notes: text actions (eg Format SQL) Tab coloring improvements You can now color a server group separately from the servers in the group. The lower status bar is now also colored. Find invalid objects ... Updates in 7.0 Environment support You can now use SQL Prompt in: Management Studio 2016 CTP2 Visual Studio 2015 The following features are now available in Visual Studio 2012 or later: Find invalid ... objects Script as ALTER Execute current statement Rename variables/aliases Encapsulate as new stored procedure Split table Red Gate removed support for Visual Studio 2005 and 2008. Snippet manager ...

Release Notes: when running the Qualify Object Names action. v10.11.9.27382 Updated Mar 30, 2022 Fixes Fixed a crash introduced in v10.11.8. Note: If you have installed SQL Prompt v10.11.8, please uninstall ... Adds command palette which provides a fast way to navigate SQL Prompt and SSMS via a single keyboard shortcut. v10.11.12.27800 Updated May 16, 2022 Fixes Fixed an issue when applying autofixes ... in bulk. Fixed an issue where try_convert formatting could cause an error. Fixed an issue where Qualify Object Names would incorrectly qualify with synonyms from other schemas. Fixed an issue when auto ...

Release Notes: v10.6.19.22009 Updated Jul 20, 2021 Features Added the ability to duplicate a tab in SQL Server Management Studio (SSMS). v10.6.18.21710 Updated Jul 7, 2021 Features Changed the way objects ... an issue where connections to multiple contained Azure SQL databases may prevent suggestions appearing. Fixed an issue where sys objects may not be suggested when connecting to Azure databases without access ... an exception would be shown after multiple failed refactorings. Fixed an issue where SQL Prompt would crash when opening the context menu of an editor window tab. v10.6.13.20795 Updated Jun 7, 2021 Features ...

Release Notes: when writing `CREATE CERTIFICATE` statements. SP-7909: Fixed filtering of string literals and SQL scripting variables when using ranked suggestions. SP-7928: The `Qualify Object Names` refactoring ... Adds support for Microsoft SQL Server 2019 and improves auto suggestion and auto fixes. 10.0.11 Updated Feb 5, 2020 Features Added suggestions support for new permission types in SQL Server 2019. ... Fixes Fixed an issue with columns sometimes not being qualified when qualifying object names. Fixed an issue with some functionality not appearing for servers connected using Windows authentication. ...

Release Notes: support for DEFAULT_DOMAIN function. Fixes Fixed a crash with Find Invalid Objects when a cached database is no longer available. 10.8.2.23489 Updated Sep 23, 2021 Features Internal changes. 10.8.1.23216 ... Updated Sep 16, 2021 Fixes Fixed a crash when opening tab history. 10.8.0.23164 Updated Sep 14, 2021 Features Added the ability to share formatting styles with other users via the Redgate Platform. (SQL ...