[Bugs] SQL Tab Magic / SQL Prompt 6

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

[Bugs] SQL Tab Magic / SQL Prompt 6

Postby Sphelabaum » Mon Jul 08, 2013 2:26 pm

SQL Prompt Version: 6.0.0.58
SSMS Version: 11.0.3000.0
Windows Version: Windows 7 SP1
Other Addons: SSMS ToolsPack 2.5.3.0
Entire Toolbelt including SQL Source Control.


Bug 1. I still get errors causing SSMS to crash with SQL Tab Magic enabled and Tab Coloring options chosen. This problem pre-existed the new version and caused my SSMS to crash repeatedly until I manually disabled Tab Magic via hand modifying the XML file. It's not as bad this time and I was able to disable it via the settings, but it is still happening.

Bug 2. When I close/Re-open SSMS, every tab I've had open since the last time I opened it, (even ones I've long since closed) re-opens. This is incredibly annoying as I tend to leave a copy of SSMS open for a week or more and connect to dozens of different servers in that time. So when I open it, 50+ queries try to re-open and prompt me to re-connect, making just re-opening SSMS a 5+ minute operation. Note: This happens even with Tab Magic Disabled and I can't find any other option to disable this.
Sphelabaum
 
Posts: 8
Joined: Tue Dec 15, 2009 6:15 pm
Location: Raleigh, NC

Postby Aaron Law » Mon Jul 08, 2013 2:42 pm

We've just released a new build (Tab Magic 0.5.0.184) which will hopefully fix your second bug:
http://download.red-gate.com/EAP/SQLTab ... bMagic.zip

The first time it's run it will still open the tabs so if you want to start fresh you can delete "%localappdata%\\Red Gate\\SQL Tab Magic\\documents.db". Any further runs should only open the tabs you had open.

We are aware the connection coloring in SQL Prompt is still a little unstable at the moment and it's on our todo list to stop it crashing ssms.
Aaron Law
 
Posts: 252
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby Sphelabaum » Mon Jul 08, 2013 3:01 pm

Perfect, thanks Aaron!
Sphelabaum
 
Posts: 8
Joined: Tue Dec 15, 2009 6:15 pm
Location: Raleigh, NC

Postby Sphelabaum » Mon Jul 08, 2013 3:22 pm

Update: It did fix the issue. The first time I opened SSMS it it still opened 25+ tabs (as you warned it would), so I closed all but 1, closed and relaunched and it properly kept just the one open.
Sphelabaum
 
Posts: 8
Joined: Tue Dec 15, 2009 6:15 pm
Location: Raleigh, NC

Postby Aaron Law » Mon Jul 08, 2013 4:27 pm

Thanks for the update! We've been struggling to track down/fix that bug for a while now.
Aaron Law
 
Posts: 252
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Re:

Postby hansjp » Tue Jan 28, 2014 11:09 am

Aaron Law wrote:We've just released a new build (Tab Magic 0.5.0.184) which will hopefully fix your second bug:
http://download.red-gate.com/EAP/SQLTab ... bMagic.zip

The first time it's run it will still open the tabs so if you want to start fresh you can delete "%localappdata%\\Red Gate\\SQL Tab Magic\\documents.db". Any further runs should only open the tabs you had open.

We are aware the connection coloring in SQL Prompt is still a little unstable at the moment and it's on our todo list to stop it crashing ssms.


I am currently testing SQL Prompt 6 (downloaded newest version in January 2014), and the issue persists in this program!
SO: Updating SQL Tab Magic might work, but the problem isn't fixed in SQL Prompt 6...

The trick of deleting the file "SavedTabs.db" (which is the only .db file on the described path) DID work as announced, though :)
hansjp
 
Posts: 1
Joined: Tue Jan 28, 2014 11:01 am


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests

cron