Keepin my windows open in Management Studio

It's a wonderful convenience for me to open up a Mgmt Studio project and have all the windows come up that I had when I closed it. I tried saving everything as a project before I closed. This morning, the desired result happened when I opened Mgmt Studio and opened the project: all my windows were open just like I left! It was wonderful! So I worked, saved the project before I closed out again. When I reopened later, the windows didn't come up again.

Can anyone give me advice on a step I may be missing? Since it happened once, I know it can be done.

Btw, I have upgraded my client tools to SP2.

Thanks in advance!

You can create your own shortcut for SSMS and add whatever additional arguments you choose based on the command line options for sqlwb.exe. You can look up the options in books online under the topic sqlwb utility. Or the online version of this help topic is at: http://technet.microsoft.com/en-us/library/ms162825.aspx

-Sue

|||

Thank you for your response. However, I cannot find any switch to remember which windows I had open at the time of closing. I was hoping to find something to how VS operates in that everytime I open it, it opens exactly the way I left it.

|||

Not it doesnt unless it crashes and manages to recover the files which were open. Please fell free to post a suggestions on the http://connect.microsoft.com site.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thank you for the response. It's not the answer that I wanted, but it is the answer.

Keep all servers registered and connected

I have 5 servers in my Server Mgmt Studio divided into 4 groups,

Local

Production

Test

Development

In Sql 2000 Enterprise Manager would put the little green arrow next to your db if it was connected, I noticed that Sql 2005 does do that but it wont allow me to keep all 5 servers connected and I need them all to stay connected.

If I look under Registered Servers it shows all 5 servers there but again only 2 show as connected even if I connect the other ones they dont stay connected. I have deleted the registerd ones and re added them and still no difference.

How can I keep all servers registered and connected and then have them show up on start-up?

Thanks!

Stokh

Launch Mgmt Studio

In the Registered Servers tool window right-click on the server and select Properties

On the Properties dialog select the Connection Properties tab

Set Connection time-out to 0 (the default is 15 seconds; 0 indicates no time-out).

|||I already did that and it still does the same thing, only shows 2 servers registered and doesnt keep the other 3 connected|||I suggest you file a bug using the Product Feedback Center: http://lab.msdn.microsoft.com/productfeedback/Default.aspx.|||I would also like to complain about this new 2005 behavior. As a DBA managing dozens of servers, it is ridiculous to keep jumping through the connection hoops in 2005 whenever I switch server context. It's hard to believe MS could screw up something so basic... and something that worked perfectly well in 2000.|||The best thing to do is search the Product Feedback Center for the issue and vote on it. In SP2 we are targeting many of the annoyances of the Mgmt Studio but we need your votes. The voting system let's us know what issues are causing pain for people and those tend to float to the top part of the list.