Could you make the explorer windows remember how they were set? I keep a good deal of one off scripts in a series of folders in the script explorer. I would like it if either all of the folders would expand by default or if the explorers would remember their layouts.

Thanks!

In theory, on startup the explorer windows should appear in the same position and have the same width that they had when the application was last closed.  So if I drag the T-SQL Script Explorer and pin it to the right side of the screen that's where it should be when I next start up the application.

With regards to the folders, we don't automatically expand the top-most folders on project startup.  However, if you expand the top-most folder and then expand either "Public T-SQL Scripts" or "Private T-SQL Scripts" it should automatically expand any folders that you had previously expanded.

The same should apply to the Project Explorer folders and databases.

If you're not seeing this behavior then let me know.

---

SQLDBcontrol Support

support@sqldbcontrol.com

If I stack all explorers on top of each other so that I can select wich one I want to see with a tab the positions are not remembered. I understand your point about not expanding the top level folders.

I think I understand what you mean now but correct me if I'm wrong.

If I stack the explorers on top of each other, when the project opens they still appear stacked up on top of each other but it always opens the left-most tab regardless of which tab I was working in last.

I'll see if we can correct that so it always opens the most recently used tab.

---

SQLDBcontrol Support

support@sqldbcontrol.com

I didn't realize that it is remembering this per project.

So is setting per project / per user?

It seems to me that once I set a window layout it would remember it whatever project I opened.

Ah,

now I see where the problem is.  Yes, each setting is saved on a project and user basis.  Originally, the main thinking behind this was that some users create different projects for different reasons.  For example, one user created a project exclusively for managing scripts and therefore wanted the script explorer to be prominent.  So we went with saving the layout on a project basis.

However, you can specify that you want the current layout to be the default layout for all projects.  You can do this by selecting Tools > Make Current Layout Default.  This layout will then be applied to all new projects that are created.

We should add an option to apply the current layout to existing projects but there is a quick workaround that you can do if you want to apply the current layout to each project now.

Make the current layout default as described above.  Then browse to "...\My Documents\SQLDBControl Projects\".  Make sure there is a DefaultLayout.xml file in this folder.  Now, each project has its own folder in here and within each project folder there is a Layout.xml file.  If you delete the Layout.xml file in each project folder then, on project startup, the default layout will be used.

---

SQLDBcontrol Support

support@sqldbcontrol.com