I have talked to several other DBAs about this and we agree, the SSMS is driving us more nuts than we already were.
1. How do I get it to save settings so that I don't need to manually tell it to reconnect to my favorite servers
2. In the Jobs tab of the Agent window, how do I get it to show scheduled times for all jobs, not just if they are running or not Can that view be modified and saved and if not why not EM was much better at this. It gave a great summary screen. Now I seem to have to look at the settings for all jobs one by one. This stinks. I need to see all jobs scheduled to run at 9:00 pm. The filter option is useless, since it is for names only, not running/idle or specific time ranges.
3. Why is it so slow to pull up stuff
4. Why should I have to screw around with an unhelpful browse window when I just want to add a new user to a DB EM would just display a list of the existing users. SSMS should do the same without that extra step of a browse window.
5. Why is it so slow
6. Did I mention that it is a dog
Modifying Management Studio to Save Views/Settings
Marko Tekavc
How do I get it to save settings so that I don't need to manually tell it to reconnect to my favorite servers
Thanks
Walter
waltw@waltw.net
cues7a
Answers to some of your questions:
1) The window layout is save automatically at exit. You do not have to save it yourself. For connections - SSMS prompts you to connect to the last server you have been connected to. Currently there is no way to connect to multiple servers at start-up. You can define your registered servers and open a connection to each of them with a double-click.
2) Have you looked at Job Activity Monitor. It's under SQL Server Agent node in Object Explorer. I think it shows the information that you need, all in one place and with ability to filter on any column.
3) We made a lot of effort to improve performance of SSMS before RTM. I agree there is still room for improvement. There are plans to address some of those issues in subseqent service packs. If you can provide more specific examples, that would be great.
4) Are you refering to 'Browse Logins' dialog We have a generic way of selecting various objects in database, that way the user experience is consitent across various dialogs. If you know the name of the login that you want to use, you can type it in without browsing.
In general, if you have a specfic issue, please report it through product feedback web site (from SSMS, select Community -> Send Feedback. Those issues are logged directly into our issues database and are reviewed to be addressed in next release or next service pack. You can also rally people to vote on specific issues, so we can easily identify the most important ones.
Regards,
Siddhartha Dutta
I totally agree with seeker of this most wanted setting in SSMS which, one has to connect he server every time. Well, that was the game in SQL 2000 was too but the beauty was EM (Enterprise Manager) was able to this fuctionality all in one where SSMS has two divison Regi. Servers and Object Explorer. I don't why MS can not club the same
Another area which lot of people might have talked about is Task Pad. Microsoft must realize that they give SQL 7.0 and SQL 2000 with same EM look and feel for almost 9-10 yrs and all users have used it for long long time. What is the problem of giving them back that Task Pad. At least it was very very useful to me to look at how full my data and log files were If you have worked with Dataware house or Large size db's with multiple files and file goups you will understnd my cry.
I know people from MS will try to justify by all those reports (which are good in its own class) but you cann't beat that feature of EM. It is like if you habituated with specific coffee and MS wants you to change your type may not be the brand. I am DBA and I was using it every day.
Do some thing on it if you guys can.
- Mukesh