Sometime, my sql query script have too much nested condition and I need to see the indent guides line like this image:
It would be awesome if you include this feature in this product.61 votes
To get an ALTER script for an existing stored proc or UDF you just need to right click it in Object Explorer and select Modify. For views you can't do this. You have to select "Script view as.." then "Alter to..." then "New query editor window". It's only two extra mouse clicks but they are two very annoying mouse clicks! I was hoping this would have come back for SQL2012 as you used to be able to do this in SQL2000, but it hasn't. Redgate to the rescue?42 votes
Show a visual indication when open transactions exist in a query window (@@TRANCOUNT > 0)
It could be changing the background color of the query window, and a number in the status bar showing the current transaction depth or something like that.34 votes
1)Automatically name tabs generated by modifying a stored procedure in the Object Explorer. I noticed you added the functionality to right-click on a procedure name in-line and generate an ALTER script. That's AWESOME, and even more awesome is the fact that the tab is named by default. Usually tabs in SMS have some dynamically-generated name that's useless.
2) add ability to rename a tab without saving the contents of the tab. Just a right-click->Rename
3) Hovering over a tab should give you a pop-up with the first dozen or so lines of text in that tab.33 votes
If I have more open tabs than can horizontally fit the window SSMS does not show all of them but instead there is a dropdown in the right upper corner. I would prefer if I could have multiple rows of tabs instead, like in VS. Since it does not seem likely that MS is going to implement that soon, can it be done in SQL prompt?33 votes
When working all day long with serveral SQL servers, its really annoying to click on "change connection" button + enter the server name you want to connect to, and enter credential.... It would be really great we we would have a "server connection list" where we could build into settings.... So i could add all my server i'm use to connect everyday, and specifying the USERNAME + PASSWORD + Default DB..... So in one-two click, i could switch to another server really quicly29 votes
I noticed the Tab History that you can rename closed tabs. It would be great if one could rename open tabs. I am constantly flipping between tabs thinking Query1 is the one where I querried table A, Query6 was the one where I updated reference table B. etc etc,,, It's a total pain.28 votes
Find all occurrences of your search string in the results in datagrid mode. I know I should and could do this in SQL but sometime it is handle to find the customers name in a large set of rows.19 votes
Can you add "choose style" or "switch style" to the commands section, as a drop down, so that it can be added to the SQL PROMPT toolbar? Or possibly as a hot key menu option?
I switch styles often. There's the style I like to work in, a style suited for debugging, and the style that management likes the code to be posted with (in TFS.) Being able to switch between them is very helpful. but, going to SQL Prompt --> Options --> Styles --> Selecting Style "with the mouse" is time consuming.
Thanks for your consideration!
Lawrence Barnes18 votes
The reason I would like to see the folders is strictly for organizational purposes. I have so many procedures and tables in one database that I have to scroll through them all to find what I’m looking for. If I could organize by schema (or however I choose) and very quickly and jump back and forth between the different folders, that would help me out tremendously. The SQL filter function is so slow when going back and forth.
What if I could organize sql instances that I'm connected to in one SSMS. Production and Development folders?? Just another thought.17 votes
It would be perfect if we could change the keyboard shortcuts, I like to use Ctrl+Enter shortcut to execute current statement (like Oracle SQL Dev) and I can't change the default Shift+F5 on SQL prompt.16 votes
1) add a possibility to set custom colours to tabs
2) pin in/pin out tabs
3) automatically set colour for executing queries tabs
4) add possibility to pop-up windows when query execution finish15 votes
It would be nice to compare 2 objects (tables / stored proc ets), by right clicking on them and select to compare (lig scema compare).
I am using to to clean up an old DB with a lot of copyed code and tables.14 votes
Can all the SQL Prompt features be made available for SQL Server Data Tools in Visual Studio 2015?
Like Tab History, Tab colours etc.13 votes
Hi - export to excel is a great feature. if it could be extended in 2 ways it would be even better.
1. copy the sql used to produce the results (and date, server info) into a separate tab called 'sql' or something. this way data extracts will be 'auditable' and re-runnable.
2. have some export options (top row = bold, highlighted, freeze top row). column autowidths applied.
the second one can be done with a macro in the excel template but would be a nice to have.12 votes
When I hover over a table name, and I can see the script, as well as a summary including data types - I'd also like to be able to see a preview of the table's data. I understand temporary tables wouldn't be able to do this. It would save me the time of writing a select statement to view the top 50 rows.12 votes
Have a Documentation tab next to the script & summar tabs on the table/stored proc popup window that shows the Sql Doc documentation.
This would make Sql Doc a lot more useful if the information you entered was displayed along with the other nicely formatted information in the popup window in Sql Prompt for table, stored procs, etc.12 votes
Can we get an change in the table icon, or an indicator in intellisense (ideally both), that lets someone know there is a trigger on a table? Triggers are often hidden, and it would be nice to have them marked in SSMS, as well as noted when someone is altering or querying a table.11 votes
I frequently need to work on longer procedure or scripts, and the longer the script gets Sql Prompt gets more and more bogged down, to the point I just turn it off. It would be nice to be able to toggle it from the toolbar rather than open the options to un-check 'Use SQL Prompt'11 votes
Not from the toolbar, but with SQL Prompt 5.2 you can easily turn prompting on and off with Ctrl+Shift+P or directly on the SQL Prompt 5 menu.
This is an old problem that just won't go away.
The Red Gate toolbar that holds the SQL Prompt icons (Tab History, Add-ins, SQL Test, SQL Search) will not persist it's state in SSMS. You can move it, but it comes back to the same place on it's own row. You can delete it, but it comes back again.
Recommend (a) making the toolbar's state persistent in SSMS and (b) added a feature to the Options menu that allows the user to remove it.
Using SQL Prompt 220.127.116.118 on SSMS 11.0.5058.0 (2012).11 votes
Thanks for your help tracking this down! I’ve made a fix for the permission issue here:
Which should work without having to run as an administrator. We’ll look into getting this included in the SQL Search and Developer Bundle installers.
- Don't see your idea?