SQL Prompt 6 - Disabling History Tabs reload on startup

Provides intelligent code completion for SQL Server editors.

SQL Prompt 6 - Disabling History Tabs reload on startup

Postby jedwork » Mon Feb 24, 2014 12:01 pm

I have an issue where I had severla 2008R2 SSMS sessions open, each with many SQL query windows.

My machine crashed and now when I try to start SSMS, the SQL Prompt tries to open all my previous sql windows, and then just crashed SSMS.

Is there a registry entry I can change to disable "Restore open tabs when SQL Server Management Studio starts" ?

If not, can I remove the backedup files myself?
SQLPrompt_6.2.0.241.exe and SSMS 10.50.1600.1

Posts: 2
Joined: Mon Feb 24, 2014 11:53 am

Postby Aaron Law » Mon Feb 24, 2014 12:26 pm

Hi jedwork,
You can turn this off manually by setting OpenTabsOnStartup to false in "%localappdata%/Red Gate\\SQL Prompt 6\\ RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml"

Roughly how many tabs were opening that caused the crash? I'm wondering if having an upper limit for the number of tabs sql prompt will try to open would avoid this in the future (or a confirmation if it's over a certain amount)

Aaron Law
Posts: 406
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby jedwork » Mon Feb 24, 2014 12:34 pm

Ta, Ill try that.

There were 179 historical files in my
H:\\My Documents\\SQL Server Management Studio\\Backup Files\\Solution1
directory of which 99 were non zero in size.

Not sure how many of those SQL Prompt was trying to open however.
This was a comedy of circumstances that lead to such a high number of files, so I don't expect this situation to arise again. Usually I only have about 20 or so open.

An upper limit, or even a prompt window on opening, to allow the user highlight those files to open might be useful if a threshold is breached.
Posts: 2
Joined: Mon Feb 24, 2014 11:53 am

SSMS crashing

Postby bgsisson » Wed Apr 09, 2014 2:44 am

I was having pretty much the same issue, and changing the config value to false worked. SSMS was opening 40-50 windows, most of which were empty. I've never had that many windows open at a time.When SSMS didn't crash on startup Win7 would revert to the basic color scheme, and often at least one of the open windows in SSMS would have a large X, corner to corner.
Posts: 5
Joined: Fri Oct 26, 2012 5:25 pm

Return to SQL Prompt 6

Who is online

Users browsing this forum: Bing [Bot] and 0 guests