680 results found
-
VSCode integration.
I've used SQL Prompt for 20 years. I would LOVE VSCode integration.
93 votes -
Toggle SQL Prompt Suggestions
I love the immediate suggestions when I need/want them, however when I do not want them, the suggestion box ends up blocking my screen more than it helps (Often blocking code I want to reference in a future query) and there is not a good way to make the suggestion box go away without clicking away from wherever it was suggesting.
I know I can delay the popup and manually show suggestions with ctrl+space, but I would love to be able to manually hide them as well with ctrl+space as a simple toggle. It would greatly help me and other…
3 votes -
make update notification window resizable or autosize with Windows zoom
I like to use the Windows zoom feature to make text bigger. (Not the dpi size feature, but rather the text size feature listed above the dpi setting.)
With this increased, I cannot see the links in Red Gate update notification windows. I'll open SSMS and get a notification for prompt that I am running 1.0.7 and the latest version is 1.0.8. There is a details link that allows me to upgrade. I can also upgrade by downloading the latest version of the tools from the Red Gate web site.
However, for minor upgrades, I often skip the upgrade process…
1 vote -
Show Code Window Even if Schema is Missing
When I scroll over an object *table, view, function, stored procedure), SQL Prompt typically displays a tooltip that describes what the object is (e.g. Table). I can click on the tooltip and see a script of the object.
However, if I have not included the schema, then I do not get the tooltip, but rather a warning that "Schema name for table or view is not specified" and I am not able to view the object code without either disabling that alert or adding the schema name.
While it may be advantageous to have this rule enabled, it would also…
1 vote -
Colorize vertical tabs
Tab coloring doesnt work in vertical tabs mode
2 votes -
Add a “Save Results As” Excel option
This is needed because I am required to run SSMS with elevated rights.
My regular Windows login doesn't have access to my database servers, and my elevated account doesn't have access to my MS 365 office suite.
Because of this, the "Open in Excel" feature is not useable.
1 vote -
HoverOver Popup Incorrect
Using SSMS 21.4.8 and SQL Prompt 11.0.6.17341.
Using a derived select to retrieve data then derive select that to change the data types then a third derived select to present the data.
In the inner most SELECT, the fields OrderID and OrderItemID are Integer in both the the Microsoft and SQL Prompt HoverOver popups.
In the outer most SELECT, the OrderID and OrderItemID are Varchar in the Microsoft HoverOver popup but Integer in the SQL Prompt HoverOver popups.
Also in the outer most SELECT, down in the ORDER BY, they show differently hovering over between the Microsoft and SQL prompt…
1 vote -
Go to variable definition
I would like a feature that allows a user to right click on a variable name and allow for an option of
Go To Declaration
so it would scroll up to the place where the variable is declared. The hover option shows how it is defined, but not where it is defined which is also extremely helpful when troubleshooting and researching a script.6 votes -
Alignment of nulls
How can we get the following alignment with nulls? Please review the pre & post images attached
1 vote -
Keyword KEEP_CDC not recognized in RESTORE statement
Add support for the KEEP_CDC keyword. Example:
RESTORE DATABASE MyDB FROM DISK = N'\\SOMEWHERE\MyDB_FULLBACKUP1.BAK' WITH FILE = 1, MOVE N'MyDB_DATA' TO N'M:\SQLData1\SQL_DATABASE\MyDB.MDF', MOVE N'MyDB_LOG' TO N'M:\SQLLogs1\SQL_DATABASE\MyDB_LOG.LDF', RECOVERY, REPLACE, STATS = 1, KEEP_CDC, NEW_BROKER, RESTRICTED_USER
Currently the formatting process errors out.
1 vote -
Add IntelliSense/AutoComplete Support for ALTER ROLE...ADD/DROP MEMBER Statement
I originally submitted this as a support case when I saw that there was no IntelliSense suggestions when writing an ALTER ROLE...ADD MEMBER or ALTER ROLE...DROP MEMBER statement (the former doesn't show potential users/groups for completion and the latter doesn't show current role members for completion), but after investigation on the Redgate side I was told this was a feature that was never implemented.
It would be great if we could get support added for this please, as ALTER ROLE is a core statement that has been around for many versions, and also because the alternative methods (e.g. spaddrolemember…
1 vote -
Option to hide "find invalid object" menu
This feature crash SQL Server because our procedures multi-databases, encrypted and so-one and not a needed feature. But the menu is misclicked lot of times and crash SQL Server.
Could you please, add an option to hide "find invalid object" menu1 vote -
Automate replacing variables with literals for troubleshooting stored procedures
Quite often when troubleshooting a stored procedure, it is helpful to step through it and run each statement individually. In stored procedures that take parameters, though, you need to manually swap out the variable name for a test value in each statement, or put variable declarations and sets in front of each statement.
It would be convenient if SQL Prompt could automate this process. It could check for parameters, prompt the user to provide values for them, then do the variable-to-literal substitution throughout the code. It could then provide an easy way to reverse the change to support committing the…
1 vote -
SQL Search endpoint for Fabric
Make SQL Search work with Fabric
2 votes -
Add or detect missing 'N' on inline string literals containing Unicode characters
This is an extension of:
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/6779217-add-n-to-unicode-type-literal-stringsExcept I would like to improve this feature so that it is not limited to just variable declarations, but also for inline string literals.
For example, if an inline string literal contains a unicode character, it should have the N prefix. If anything it should probably be a Code Analysis rule rather than formatting because this change can absolutely impact code behavior. So I think it's better suited to be an analysis rule.
5 votes -
exclude suggestions
SQL Prompt includes a feature to exclude specific databases – in this case, the master database – we would expect this functionality to reliably prevent any interaction with the excluded databases during code suggestions or IntelliSense operations. The current behavior suggests that the exclusion option may not be functioning as intended.
We expect that when an exclusion is defined, no connection attempt should be made to the excluded database. This would allow all other user databases to be loaded, even if with limited functionality.
pls. check http://productsupport.red-gate.com/hc/requests/333558
1 vote -
Set preferences for automatically numbering new queries
New queries, as users know, have an automatic naming and numbering system:
SQLQuery1.sql, SQLQuery2.sql, SQLQuery3.sql, etc.It would be helpful sometimes if the queries could have leading zeros or maybe even a different lead-in like the name of the solution. For example, SQLSolutionABC might have the default tab names:
SQLSolutionABC001.sql, SQLSolutionABC002.sql, SQLSolutionABC003.sql, etc.
1 vote -
Add support for Fabric warehouses and lake houses
Add support basic intellisense support for Fabric warehouses and lake houses.
35 votes -
Add a warning for using a self-join in a delete or update statement
Add a checkbox to the warnings settings, for if a self-join is detected when doing an UPDATE or DELETE.
1 vote -
Generate script for Table Types
When hovering over a Table Type the pop-up window only shows tabs for Summary and Dependencies. Add a Script tab for consistent functionality when compared to other types of object such as Stored Procedures, Tables, Views, Functions etc.
2 votes
- Don't see your idea?