Red Gate forums :: View topic - SQL Prompt 6 - Disabling History Tabs reload on startup
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

SQL Prompt 6 - Disabling History Tabs reload on startup

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jedwork



Joined: 24 Feb 2014
Posts: 2

PostPosted: Mon Feb 24, 2014 12:01 pm    Post subject: SQL Prompt 6 - Disabling History Tabs reload on startup Reply with quote

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

Ta
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 249
Location: Red Gate Software

PostPosted: Mon Feb 24, 2014 12:26 pm    Post subject: Reply with quote

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)

Thanks,
Aaron.
Back to top
View user's profile Send private message
jedwork



Joined: 24 Feb 2014
Posts: 2

PostPosted: Mon Feb 24, 2014 12:34 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
bgsisson



Joined: 26 Oct 2012
Posts: 5

PostPosted: Wed Apr 09, 2014 2:44 am    Post subject: SSMS crashing Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group