674 results found
-
Open a pre-configured list of servers in Object Explorer when SSMS starts
In the setting of SQL Prompt there should be an option to create a list of servers.
When SSMS then starts It should automatically create a connection to this list of servers in Object Explorer.
It would be a great feature, when working with the same servers, it takes a long time to connect to servers everyday when work starts :-)
5 votes -
Implement all SQL Code Guard Rules in SQL Prompt Code Analysis
There are several rules that are only available in SQL Code Guard. And with SQL Code Guard no longer being maintained they should be implemented in SQL Prompt Code Analysis so that we can avoid having to use two products.
By our count here are the rules currently not implemented in Code Analysis:
DEP004 COMPUTE and COMPUTE BY clauses are deprecated
DEP005 FASTFIRSTROW table hint is deprecated
DEP008 PASSWORD/MEDIAPASSWORD options in BACKUP/RESTORE statement are deprecated
DEP010 DBCC CONCURRENCYVIOLATION is deprecated
DEP017 NON-ANSI join (= or =) is used
EI001 Incompatible variable type for procedure call
EI002 Incompatible literal…5 votes -
PE019
I'd like to vote for adding PE019 (Consider using EXISTS instead of IN) to the issues which can be auto-fixed.
It feels like the kind of re-write that would probably be simpler for a computer to do than a person.
5 votes -
Universal user settings ("run as different user" scenario)
I use two AD user accounts on a daily basis - a normal account and a "server admin" account (for server OS local admin and SQL instance sysadmin permissions). Hence, I run SSMS as either one or the other user. SQL Prompt settings (same goes for other Redgate tools) are saved per user, which makes it quite tedious, since after every setting change I have to export from that user and import to the other user.
Can you it an option for settings to be user independant (universal)?
5 votes -
Custom Warnings in SQL promt
Custom Warnings.
For example, we have juniors who are just starting out in the SQL server world, Id like to have warning for Select statements that do not have Nolock hints. As the juniors will never be running any updates and deletes, they only have read access, but currently sometimes people forget the nolock hints and start causing locks and so on.5 votes -
Comment in /* */
Is it possible to add a hard return after the /* comment */ block so code doesn't keep formatting after the comment
Currently:
/* comment */ UPDATE User
SET Modified = CAST('2018-12-20' AS datetime)
WHERE id = 255454Suggestion
/* comment */
UPDATE USER
SET Modified = CAST('2018-12-20' AS datetime)
WHERE id = 2554545 votes -
Management Studio 18.0 Support
SSMS 18.0 support, the latest till now, doesn't support ssms 18 preview 4
5 votes -
Format of Valid Selected Code when there is invalid code in the script (Take 2)
Version 9.2.5.6073
I would like to request that script validation be limited to the selected text during Format SQL.This is a duplicate of a Completed feature (Bug) submitted on version 7. https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/16611622-formatting-of-valid-selected-code-when-there-is-in
I see recent comments on the original request but you may not be addressing since it is marked completed.To Replicate:
Put 3 lines below in a new Window in SSMSSOME BAD TEXT
GO
SELECT 1 FROM dbo.PersonNow select All of Line 3 after the GO Statement. Right-click, Format SQL
Should get following error:
"Error inserting semicolons" ...
Script parsing errors:
Line 1 Col: 1…5 votes -
IF Statement block formatting is messed up
IF Statement block formatting is messed up
IF 1 = 1
BEGIN
PRINT 'DO STUFF'
ENDbecomes
IF 1 = 1 BEGIN
PRINT 'DO STUFF';
END;which is what I want...I want to leave the BEGIN END indention
5 votes -
Empty Line Before and After Multi-Line Statements
Complex multi-line statements are much easier to read when separated by an empty line above and below them. Please add an option to turn on "Empty Line Above/Below Multi-Line Statements".
5 votes -
Have column selector available on insert statements
I noticed as a new user that when I type in INSERT INTO [table_name] ( column1, etc) that the column selector option is grayed out. When building insert statements that use a select to provide the data being inserted I have to manually select each column. Could you enable column picker in an insert statement?
5 votes -
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 Declarationso 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.4 votes -
open excel with different account
Configure a different account than the one opening SSMS to open Excel for results. We use an Admin account for DBA work separate from our Windows account.
4 votes -
Sql prompt support for Dedicated SQL pool
Add support for Dedicated SQL pool on Azure Synapse.
4 votes -
Automatic updates for SQL Prompt without the need for administrator privileges
Currently users have to install SQL Prompt updates manually and this requires administrator privileges which is not ideal in a workplace setting. I was wondering if this could be changed so that SQL Prompt updates itself without the need for manual install and administrator privileges.
Thank you in advance for your help.
4 votes -
Export to Excel bug -- Excel says it needs to repair data
Since upgrading to latest version of SQL Prompt, I seem to be getting an error from Excel when I choose "Open in Excel". The XML recovery log looks like this:
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error09000001.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\ned.bush\AppData\Local\Temp\raovxova.xw3\Exported results 2022-10-2509-18-50.xlsx'</summary>
<repairedParts>
<repairedPart>Repaired Part: /xl/worksheets/sheet1.xml part with XML error. HRESULT 0x8000ffff Line 1, column 0.</repairedPart>
</repairedParts>
</recoveryLog>4 votes -
Script as Insert
With the Script as INSERT feature, give the option to just copy the CREATE TABLE and INSERT INTO statements to the clipboard.
I regularly create Temp Tables to store query results when working through a SPROC. (Generate a dataset, throw it in a temp table to use for later, drop it at the end of the SPROC. More efficient than doing one massive Select with Subqueries.) When you Script as INSERT, that's created in a new tab. I copy that code and go back to the original tab.
Would be convenient if I could copy straight to the clipboard and…
4 votes -
Format on Save
Allow an option when saving / running a file that you format the sql to the format selected. Will make sure the whole team follow the standards and does not forget to run the formatter.
4 votes -
Allow SQL PROMPT to resolve constants in an ORDER BY clause
If I create a query with an ORDER BY clause such as ORDER BY 1, 2; SQL Prompt will flag the ORDER BY and report ORDER BY clause with constants.
It would be nice to have an option to have SQL Prompt replace the constant(s) with the correct column names.
4 votes -
«Script as INSERT» should include SET IDENTITY_INSERT «table name» ON & OFF
When using the «Script as INSERT» functionality, I always have to manually wrap the INSERT statements with SET IDENTITY_INSERT «table name» ON and OFF.
The state of the IDENTITY-property of the PK is available. Would you please at least include a togglable property to allow for the automatic addition of this very useful functionality please?
4 votes
- Don't see your idea?