17 results found
-
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
-
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! -
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 -
Exclude Identity Field From Auto Generated Insert/Values Code For Table Variables
If a table variable or temp table has an identity field, I do not think this field should show up in the auto generated insert into/values list:
DECLARE @Table TABLE (TableId INT IDENTITY(1,1), Data VARCHAR(100);
INSERT INTO @Table
( [TableId] -- This field show not show up by default in the insert list
, [Data] )
VALUES ( 0 -- TableId - int -> This field show not show up by default in the insert values list
, '' -- Data - varchar(100)
)-- Temp Table
CREATE TABLE #Temp (TableId INT IDENTITY(1,1), Data1);INSERT INTO [#Temp] ([TableId],
[Data1]) VALUES…2 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Tab History (aka SQL Tab Magic) should not show currently open windows
I love Tab Magic (or Tab History), but the with the latest version it also shows the tabs that are currently open. I would like an option to ignore currently open tabs. I can search those tabs right in SSMS, I need Tab History just for ones I've already closed.
2 votesWe’ve added a “closed tabs” option in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add connection limit for restoring tabs
Please add an option to ignore tabs over a certain number of connections.
It would avoid long waits when SSMS starts if in the previous session I forget to close a one-time query against hundreds of servers.
In its current implementation, SQL Prompt can crash SSMS before the connections complete.
See SQL Prompt forum for context:
http://www.red-gate.com/MessageBoard/viewtopic.php?p=718343 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
1 vote
-
Enable "reconnect to server" on SSMS startup
Reopening tabs is a great feature. HOWEVER, to have all the tabs sit there saying "not connected" means I have to manually reconnect to every one of them. Quel pain! Being in the middle of a time-crunch project with 12 tabs sitting there all disconnected motivated this request...
Please present the Tab Magic overlay and give us:
1. the option to "connect to last connected server with last-used credentials" for selected tabs.
2. the option to choose another server from the list (it's OK if the connect dialog pops up once the overlay is dismissed).
3. the option to remove…3 votes -
What happened to the options settings for Tab Magic? I rarely, if ever, want the last tab opened and would like to be able to stop it
What happened to the options settings for Tab Magic? I rarely, if ever, want the last tab opened and would like to be able to stop it from doing so every time I start an instance of SSMS
2 votesWe’ve released SQL Prompt 6 which includes the tab magic options.
-
Tab Magic EAP hijacks CTRL-T completely.
Do not hijack CTRL-T in Tab Magic. I routinely use this to direct query output to Text. I use this in concert with CTRL-D, for output to Grid.
Perhaps when options for Tab Magic are provided, we will be able to turn off this feature.1 voteWe’ve released SQL Prompt 6 which includes the ability to change the keyboard shortcut.
-
query history starts at Open Queries;
I would like a config open so that the dropdown of queries starts at OPEN QUERIES not all queries
also, I would like it when my mouse hovers over the magic tab button for it to just expand... the extra click makes it less magic
3 votesWe’ve released SQL Prompt 6 which includes this.
-
Show Long file names in Query History in Tool Tip
Hi,
Thanks for your last changes!
In addition, I have sometime Long file names where only looking on their Name tail or according to their full path, I can decide which one is the relevant.
Could you add in Query History a Tool Tip when hovering above the File Name with Full Name, Path, Last Closed, Last Connection details, etc.?THNX
Jermy1 voteWe’ve released SQL Prompt 6 which includes this.
-
Bulk Delete old tabs
It would be great to be able to bulk delete old or unneeded tabs from Tab History. Right now, I have to delete it one by one which is an endless task.
8 votesWe’ve released SQL Prompt 6 which includes this.
-
SQL Tab Magic - When searching query history the text in the preview pane jumps to the left
Hi,
First, I like the new design, and thank you for make it available for SSMS 2012.
I have 2 problems:
1. I missing the Option button (I don't wont it to open recently closed queries on start-up).
2. When I'm searching for term in the Query History dialog, and hovering above one of the files in the left pane, its query text in the preview pane jumps to the somewhere in the file and move a bit to the left. I assumes it suppose to jump to the first match, but, it is not always even in the frame.…3 votesWe’ve released SQL Prompt 6 which includes a fix for these.
-
Support Tab Magic in SSMS 2012 ASAP
The VS-based "tool" is significantly less usable than SS2008R2. Tab Magic will significantly ease the pain of having to work with tabs in the limited manner SSMS2012 inflicts upon us, especially those of us livid over the loss of the MDI-mode!
91 votes -
SQL Tab Magic - Connection attempts
When loading management studio it would be great if tab magic could get a list of the required connections before the tabs are loaded and test each one silently to see if a connection would be possible (i.e. host is available) If the host is available then prompt for login once per host, if host is not available simply load the tab as not connected.
This would make the experience much nicer as at the moment if I had say 15 tabs open to a host that I am no able to connect to (I work on multiple sites) I…
8 votesSQL Prompt 6.1.0.71 will try a silent background connection before getting SSMS to connect the query.
-
SQL Tab Magic - Recently Closed Tabs navigation
When I click on 'Recently Closed Tabs' I get a window showing 20-ish closed tabs and their contents. If I resize the window, it fills with more, so I know that further history can be accessed.
I understand that the best way to find 'old' queries is to type in the search box to try and filter the history, but sometimes (and it is only sometimes) I just want to scroll down the history and see all the closed tabs. Not saying all the history should be loaded - I guess that would take a lot of memory, but it…
5 votes
- Don't see your idea?