270 results found
-
SQL History keyboard shortcut
Just like Tab History has, SQL History should have a keyboard shortcut to open the window.
2 votesHi there,
Thanks so much for the message.You can also use CTRL+SHIFT+X to access SQL History.
I hope this helps! -
SQL History initial cursor location
When opening SQL History, it should default the cursor to the search input box instead of requiring an additional click to start a search. Since 90% of the time I'm going to input a search, it makes sense to put it there.
This has no downside as, currently, the cursor doesn't by default go to anything.
2 votesHi Adam,
Thanks for the feedback, really helpful.
James
-
When generating Insert code use defaults
If you create a table with a BIT column not nullable with a default value, and then you type insert, the autocomplete gives you null for the bit column. Example below. (I haven't looked at what happens with other data types/defaults.)
CREATE TABLE dbo.MyTable
(
Flag BIT NOT NULL CONSTRAINT DFMyTableFlag DEFAULT (0)
)
GOINSERT INTO dbo.MyTable
(
Flag
)
VALUES
(NULL -- Flag - bit
)1 voteHi,
This feature has actually just been added to SQL Prompt, and will be included in the next release (10.6.11).
Thanks,
Owen
-
MFA (multi factor) Support for Azure SQL Databases
Support Azure multi factor authentication for accessing Azure SQL Databases.
69 votesThis was shipped in 10.4 https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-4-release-notes
Thank you for your input!
-
Turn off notifications such as "Slow cached time detected".
Have the ability to turn off notifications such as "Slow cached time detected". I see it every time I connect to a database - and I work with every element in the db's so I want it all to be cached. But I do not want to see this notification every single time.
34 votesI’m pleased to say SQL Prompt 9.5.13 has just been released, which allows you to dismiss a notification forever. The next time you see “Slow cache time detected…” just click the ‘x’ and the product will never show that notification again.
You can download that version from http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.13.11024.exe.
Please get in touch if you have any other issues.
Thanks
Tom
Team Prompt -
Be able to open a tab from tab history even when no other ssms tabs are open
Currently when you attempt to open a tab from tab history and there are no other tabs currently loaded in SSMS the attempt from tab history freezes SSMS and causes it to crash. A feature that made that not happen would be good.
1 vote -
Allow SQL Prompt to work with no access to master.sys.sysservers table
SQL Prompt fails when the user does not have access to the sysservers table in master database. It is becoming increasingly common for DBA groups to revoke/deny this permission to developers. For our org it was the result of an independent audit/penetration test. There are other procedures etc the provide the same information without this specific access. I have provided examples and troubleshooting steps to Redgate support but with no resolution. Their suggestion was to post a request here.
5 votesHi,
We released this feature in SQL Prompt 10.3.3. The only reason SQL Prompt ever needed to query the master database was to get the list of linked servers. If you upgrade to that version and ensure the “load suggestions for linked servers” option is disabled, SQL Prompt should load suggestions correctly.
Thanks,
Tom
SQL Prompt Team -
Integration with Visual Studio 2017
I'm using SQL Prompt with both SSMS (v18.5) and Visual Studio 2017 (version 15.9.23). Everything was working fine in both environments but since updating SQL Prompt to version 10.2.1.15260 I've completely lost all SQL Prompt integration in Visual Studio.
I'm aware that Visual Studio 2017 includes SQL Prompt Core but I'd always shied away from using that because I couldn't see any evidence that it would keep itself updated. When I'm building a new solution that requires a database component I find it useful to be able to add a Database project so that I can source-control everything in the…
1 vote -
Disable auto update check on startup
It would be nice if we can turn off the auto update check for a new version on start-up. This check is happening in the Visual Studio database project and in SSMS. I'd like to disable it. Thanks!
36 votesIn Prompt 10.0.11 we added a new option to the help menu called ‘update notification frequency’. This will allow you to reduce the frequency of updates all the way down to major versions only (one update a year).
-
Autofix with shortcut
A shortcut to implement the autofix changes.
Would be nice if it wasn't necessary to use the mouse when applying autofixes.It is almost there; you can press ctrl and get the error window and even just press enter then, to apply the fix. But the window stays and there is no reason to actually open the window, the fix could/should just be applied
4 votesWe added the ability to autofix issues using the Alt + Enter keyboard shortcut in SQL Prompt 10.1.
-
transparency
Hi, new feature with transparency on Ctrl in SQL Prompt 9.4.10 is extremely annoying, I'm using only Ctrl+Space to show intellisense. Please provide us option to disable this feature, or change key to Alt or Ctrl+something, this is really horrible, please fix it asap. I've to uninstall tool for now.
4 votesMany thanks for your useful feedback on this issue.
We’ve done some further work on this feature that should hopefully address your issues. This has just been released in SQL Prompt v9.4.11 (available from https://www.red-gate.com/products/sql-development/sql-prompt/).
The popups will now only go transparent after holding the Ctrl key for a short period instead of immediately. This should mitigate the issue somewhat. In addition, there is a new option (in Suggestions → Behavior → Make popups transparent when the Ctrl key is held down) to turn the feature off if it is not wanted.
Kind regards,
The Prompt Team
-
ST008
I'd like to vote for adding ST008 (non-named parameter style used) to the issues which can be auto-fixed. Hopefully it would be fairly simple to implement.
9 votesHi,
We’ve released this autofix in SQL Prompt 9.5.13.11024. Please let us know what you think!
Thanks,
The Prompt Team
-
Download install exe option during Check For Updates
Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".
1 voteWe added this option in Prompt 9.5.3. Hope it helps, do let us know if you have any further feedback.
https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes
-
Download install exe option during Check For Updates
Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".
1 voteWe added this option in Prompt 9.5.3. Hope it helps, do let us know if you have any further feedback.
https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes
-
Bring back the Ctrl+B, Ctrl+B hotkey for removing square brackets please. I used it all the time and the last update seems to have removed
I updated to SQL Prompt 9.4.7.7595 yesterday and since then I no longer have the hot key. It is still on the menu, but no hotkey. I used that feature hourly. If you wish, allow users to define the hotkey combinations or disable them, but simply removing them is inconvenient.
1 voteThis was a bug that has been fixed in SQL Prompt 9.4.8. Please upgrade to that version (or later) to restore the functionality.
-
A Create/Declare Table statement with a Primary Key gives a false positive BP014 in Code Analysis
If you have a table declared like this:
Declare @Test table
(TheKey int Primary Key,
SomeData varchar(10) Not Null)I am told that for "TheKey" "[NOT] NULL option is not specified in CREATE/DECLARE TABLE statement" defined. But, a Primary Key can never be null, so it is NOT NULL by nature.
So, when performing Code Analysis and the parser sees "Primary Key", "Not Null" should be inferred also.
2 votesHi,
I’m pleased to announce this issue was fixed in version 9.4.10 of SQL Prompt. You can access the latest version from https://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for bringing it to our attention!
Kind Regards,
The Prompt Team -
Duplicate Tab
One of the common UI interaction features in browsers like Chrome and IE is Duplicate Tab feature.
Ususally the reason you might want to do this, could be because you want to keep an UNALTERED TAB and do SOMETHING DIFFERENT with another page...
In SSMS this could be a great feature. Example of use please (- I hear you ask)? You could be trying to change script and test the effect of that change vs the original!
MUCH MUCH Further down the line, you could extend this feature, to highlight the differences between tabs, a bit similar to file compare…
4 votesHi,
We’ve added this to SQL Prompt and it will be shipped in the next release.
Thanks,
Owen
-
Add support for Azure Active Directory authentication
Referring to this forumpost: https://forums.red-gate.com/viewtopic.php?f=169&t=79794
55 votesThis is now completed and was shipped in v10.4
Thank you for your input!
Chiara
-
Command Line "Reformat All Files In Folder" and pre-Commit
Opening over 2500 code objects to set a baseline format, required by a large customer, is a daunting manual task.
Many of Red Gate's tools provide command-line functionality.
Please add it to Prompt so we can bulk (re)format SPs, UDFs, Triggers. Integration into the commit-path (we use SVN) would be ideal for standardized check-ins (Commits).
Can't recall whether a style is exportable... (License key awaited at new employer) Should be able to point to UNC location for the style to use.
109 votesBulk operations for formatting and code analysis were added as part of SQL Prompt 10.7
-
Add the option to replace NULL values for strings as empty strings when using 'Open in Excel'
When using the new feature 'Open in Excel' (the results from the grid), it'd be handy to have an option to replace NULL string values with empty strings ''. Sure you could do ISNULL on all the columns that are a string data type, but it'd be handy to just have the option to have the 'Open in Excel' feature do it.
The only way I've found to quickly do it is to export the data as a csv and use a powershell script with something like:
Export-CSV -NoTypeInformation -Encoding "Unicode" -Delimiter "," $AttachmentPath
(Get-Content $AttachmentPath) -replace "`0", "" |…8 votesSQL Prompt 7.2 now exports NULL values as empty cells when using Open in Excel. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
- Don't see your idea?