SQL 2005 Management Studio need to be improved :-(
OK this is one of my first rant of the year, and of course this is my opinion and I agree if you disagree.
SQL 2005 is a great Database software, no doubts. But I am concern by Management Studio. I believe the objectives by Microsoft was to provide a central place for all the SQL tools. The main problem is that this tool is “bloated“ to an extent it’s almost useless. Have you ever try to use it remotely when your data server is hosted externally, using for example Terminal to access the server.
In some cases, I can’t just do an update or a delete just because a table is not opened in the right conditions. Or I got too much timeout connections errors.
It’s really embarrassing from Microsoft, and I really regret the not that so bad Enterprise Manager (not perfect but in a couple of clicks I was able to do some basic remote functions like a delete or a quick update).
Now SMS is down too slow, not user friendly (too many clicks).
So maybe a suggestion would be to request from Microsoft a “light“ version close to what was Enterprise Manager for SQL 2000. at least something we can use in a remote situation.