SQL Object - SQL Prompt Bundle

  1. SQL Prompt finds invalid objects

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

  2. SQL Prompt Bundle 9.4.15

    Release Notes: to servers and databases. Fixes in SQL Prompt 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 ... Filter the suggestions that SQL Prompt shows by schemas, in addition to servers and databases. Updates in SQL Prompt You can now filter the suggestions that SQL Prompt shows by schemas, in addition ...

  3. SQL Prompt Bundle 9.5.20

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

  4. SQL Prompt Bundle 10.7.x

    Release Notes: 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 SQL Prompt Pro- Added a Bulk Format all ... in the object definition window. (SQL Toolbelt or SQL Toolbelt Essentials License Required). ... 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. ...

  5. SQL Prompt Bundle 9.5.12

    Release Notes: Updates in 9.5.12 Updates in SQL Prompt Pro 9.5.12 SP-7726: Fixed an error when selecting "Select Top 1000 Rows" in the Object Explorer. ...

  6. About SQL Prompt Bundle

    About SQL Prompt Bundle

    Description: Word documents. SQL Doc automatically includes information about object definitions and dependencies, and allows you to add further descriptions to your database objects if necessary. This stand-alone ... Add IntelliSense-style to your Microsoft SQL Server Editors. SQL Prompt Bundle includes SQL Prompt, SQL Doc and SQL Data Generator. SQL Prompt provides seamless IntelliSense-style auto-completion ... and layout. SQL Doc enables you to connect to databases and output documentation in word or HTML formats. SQL Data Generator automatically populates databases with realistc test data. SQL Prompt Bundle ...

  7. SQL Prompt Bundle 10.11.x

    SQL Prompt Bundle 10.11.x

    Release Notes: 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 ... a CREATE USER...FROM EXTERNAL PROVIDER statement. SQL Prompt Pro- Fixed an issue where constraints were incorrectly being qualified when running the Qualify Object Names action. v10.11.9.27382 Updated Mar ... were not showing in Visual Studio (Copy as IN Clause, Find Invalid Objects, Open in Excel, Script Results as INSERT, Split Table). v10.11.7.27287 Updated Mar 23, 2022 Fixes SQL Prompt Pro- Fixed an issue ...

  8. SQL Prompt Bundle 10.10.x

    Release Notes: 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 ... v10.10.4.26165 Updated Jan 18, 2022 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 ... be incorrectly indented within IF ELSE statements. v10.10.3.25844 Updated Jan 4, 2022 Features SQL Prompt Pro- Bulk Formatter added support for multiple file encodings. Fixes Fixed an error where tab history ...

  9. SQL Prompt Bundle 9.5.11

    Release Notes: Updates in 9.5.11 Updates in SQL Prompt Pro 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 scenarios. SP-7715: Fixed incorrect renaming of named parameters in Inline EXEC refactoring. SP-7719: Fixed an issue with code analysis rule BP014 and how it deals ...

  10. SQL Prompt Bundle 9.5.3

    Release Notes: of Windows or SQL Server 2005 Fixes in SQL Prompt 9.5.3 SP-7558: Find Invalid Objects now reports triggers that are on non-existent tables. ... SQL Prompt now promotes recently used suggestions to the top of the suggestions box. New in SQL Prompt 9.5.3 SQL Prompt now promotes recently used suggestions to the top of the suggestions box. ... instead of running it when SQL Prompt informs that there is a new version available. New in SQL Doc 5.0 The UI now runs as a 64 bit process. *As of version 5.0.0, SQL Doc no longer supports 32-bit versions ...

  11. SQL Prompt Bundle 10.8.x

    Release Notes: 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. 10.8.2.23489 Updated Sep 23, 2021 Features ... SQL Prompt Pro adds the ability to share formatting styles with other users via the Redgate Platform. 10.8.4.24201 Updated Nov 1, 2021 Features Internal changes. 10.8.3.23924 Updated Oct 19, 2021 ... 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 SQL Prompt Pro- Added the ability to share formatting styles ...

  12. SQL Prompt Bundle 7.1 updated

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

  13. SQL Prompt Bundle 10.1.x

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

  14. SQL Prompt Bundle 9.4.10

    Release Notes: The suggestions pop-up can now be made transparent. Updates in SQL Prompt Based on customer feedback, the SQL Prompt experimental features are not going to be deprecated yet. The suggestions pop-up ... can be made transparent by holding down the Ctrl key, allowing you to see what is behind it. The keyboard shortcut to open code analysis issues has been changed to Ctrl+Shift+E. Fixes in SQL Prompt ... BP014 no longer reports an issue with columns that don't declare NULL/NOT NULL if that column is a primary key. Qualify Object Names no longer tries to qualify column and index names when creating ...

  15. SQL Prompt Bundle supports Visual Studio 2015

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

  16. SQL Prompt Bundle 10.0.x

    Release Notes: 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 ... of string literals and SQL scripting variables when using ranked suggestions. SP-7928: The `Qualify Object Names` refactoring will now prefer synonyms over other database objects if there is any ambiguity. ... to an Azure server using Multi-Factor Authentication. 10.0.9 Updated Jan 28, 2020 Features Added Azure support for the following 33 built-in T-SQL functions: ASYMKEY_ID ASYMKEYPROPERTY CERT_ID CERTPROPERTY ...

  17. SQL Prompt Bundle 10.6.x

    Release Notes: Updated Jun 30, 2021 Fixes Fixed 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 ... v10.6.19.22009 Updated Jul 20, 2021 Features SQL Prompt Pro- Added the ability to duplicate a tab in Microsoft SQL Server Management Studio (SSMS). v10.6.18.21710 Updated Jul 7, 2021 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. v10.6.17.21532 ...

  18. SQL Prompt Bundle 10.4.x

    Release Notes: Adds support for connecting to servers using Microsoft Active Directory Universal with MFA in SSMS. v10.4.7 Updated Nov 9, 2020 Features SQL Prompt Pro- General performance improvements. v10.4.6 ... an authentication issue with Find Invalid Objects, Smart Rename and Split Table. Fixed an issue where re-authentication would be required after a Script as Alter command when using Azure MFA connections. v10.4.3 ... correctly in specific conditions. Fixed an issue where tab colors were not being persisted when changed from the Object Explorer menu. v10.4.1 Updated Sep 22, 2020 Fixes Fixed a formatting issue which could ...

  19. SQL Prompt Pro 7.2.0.260 updated

    Release Notes: Updates in 7.2.0.260 SSMS 2016 support SQL Prompt now supports SSMS April 2016 Preview. SQL Prompt 7.2 works with SSMS April 2016 Preview and SSMS March 2016 Preview Refresh, but won't work ... with earlier SSMS 2016 preview versions. Execution warnings SQL Prompt now shows a warning message when you try to execute an UPDATE or DELETE statement without a WHERE clause. Warnings aren't shown when ... modifying temporary tables or table variables. Suggestions improvements SQL Prompt now offers suggestions when connected to Azure SQL Data Warehouse and Analytics Platform System (formerly known as Parallel ...

  20. SQL Prompt Pro 7.3

    Release Notes: Improves SQL formatting. Improved SQL formatting- includes a new experimental version of the Format SQL feature, the formatting styles are now much more customizable. Added more options ... formatting styles with other SQL Prompt users by storing them in a shared folder. Create multiple formatting styles and switch between them. Disable SQL Prompt formatting for certain blocks of code. Added ... ability to inline EXEC stored procedures and scalar functions in a query window (UserVoice). Also added inline EXEC sp_executesql (UserVoice). This replaces the dynamic SQL with static SQL. Choose to show ...