Activity overview
Latest activity by JimF
Why is renaming a tab so difficult?
Hello,I'm just trying to rename a closed tab in Tab History. I can get to the Rename mode and type in the new name, but it doesn't "stick" no matter what I try and do. I have tried tabbing away, pr...
Tianjiao_Li said:
It's difficult to troubleshoot if the issue is intermittent. Few questions would help: 1- how many tabs were open when this issue occurred and were all tabs not reconnecting? 2- were the tabs that didn't reconnect from one specific database? 3- do you have this issue with any other version of SSMS? 4- if you restore the Prompt options to default (SQL Prompt ->Options->Restore all defaults), restart SSMS, does it help? 5- do you notice any pattern when this issue occurs?
1) This last time, 28 tabs were reopened, but not connected. 3 of those tabs were reconnected. Most of the unconnected tabs were pointing to the same server/database as the reconnected ones. 2) Mostly one since that is what I am currently focused on right now, but as I mentioned in #1, I did get a couple of reconnects to the same server/database. 3) Not that I remember. If I did, it was a long time ago. 4) Oh! That sounds drastic. OK, I did an Export of all of my settings and then clicked Restore all defaults. I connected a couple of tabs as a test, then restarted SSMS. I noticed that most of my tabs now reconnected with the exception of a couple that used a SQL User/Password to connect, even though I have saved the password in SSMS. 5) The only pattern that I noticed is that I have tabs open and connected, I quit SSMS. I restart SSMS, and most of my tabs are not reconnected. Now I have to try and figure out what all of the settings are that I lost, like all of my custom aliases :-( / comments
Tianjiao_Li said:
It's difficult to troubleshoot if the issue is intermittent. Few questions would help:1- how many tabs were open when this issue occurred and were all tabs not reconnecting?...
Tabs are no longer reconnecting when SSMS starts up
I have started to notice that when I start up SSMS my tabs are opening, but not always reconnecting. I have confirmed that I do indeed have "Automatically reconnect restored tabs" checked. All of ...
@Alex B , I don't have that folder. I do have "%AppData%\Red Gate\" and under that I have "SQL Data Generator", "SQL Multi Script 1", and "SQL Refactor", but not one for the Dependency Tracker. Where else would it be hiding? Thanks, Jim / comments
@Alex B ,I don't have that folder. I do have "%AppData%\Red Gate\" and under that I have "SQL Data Generator", "SQL Multi Script 1", and "SQL Refactor", but not one for the Dependency Tracker.Where...
Using SQL Dependency Tracker from SSMS—TMI
I would like to know if I am missing a setting somewhere for the SQL Dependency Tracker.I would like to use Dependency Tracker from inside of SSMS, but at it works now, it's too noisy. I would like...
@bauerju Is there a way of tracking this bug? That is, is there a public facing side to their bug tracking system? This one is a huge issue with me and I would like to keep a close eye on it's fix. If I would have know it existed, I would not have upgraded yet (and it's a pain to downgrade SQL Prompt...) / comments
@bauerju Is there a way of tracking this bug? That is, is there a public facing side to their bug tracking system? This one is a huge issue with me and I would like to keep a close eye on it's fix....
I just upgraded to 9.1.3.4467 today and I can no longer do "Format SQL" for a CREATE or ALTER PROCEDURE. (not sure if other statements cause it to fail). SQL Prompt was unable to complete this operation. Problem areas have been highlighted. Errors during parsing the script: Ln: 1 Col: 1 - Value cannot be null. Parameter name: token
I now see that this issues has been around for a few days. Is there a fix coming out soon?
/ comments
I just upgraded to 9.1.3.4467 today and I can no longer do "Format SQL" for a CREATE or ALTER PROCEDURE. (not sure if other statements cause it to fail). SQL Prompt was unable to complete this o...
Hi Andrei,
Thanks for getting back to me on that. That's very unfortunate that it does not honor the current filter. As far as removing the current item, that is actually what I would expect from the wording of the menu item.
Is there a User Voice item that I need to add my votes to?
Thanks,
Jim
/ comments
Hi Andrei,
Thanks for getting back to me on that. That's very unfortunate that it does not honor the current filter. As far as removing the current item, that is actually what I would expect from ...
SQL Tab History - "Remove tabs older than this"
Hello,
Background: I am looking at getting rid from my tab history changes that I have made to stored procedures as they are now saved in the database. I can do this by searching for things like "...
latest upgrade crashed--badly
I just did the latest upgrade today and had a very rude surprise! I was told that the installation of 7.3 failed
Service 'Redgate Client' (RedGateClient) could not be stopped. Verify that you hav...