I’ve been using Microsoft SQL Server Enterprise Manager for a few months now, and compared to command line SQL, this application is useless. Sure you can view the records in a table….by right clicking on the table and choosing Return->All Rows. What ever happed to “select * from table”? Is that too much to ask?
To add to the frustration, it frequently asks me if I want to continue working with my result set. Uh, yeah, I’ll tell you when I’m done with it when I CLOSE THE FRIGGIN WINDOW MYSELF! Glar. For those of you not able to imagine this, it would be as if your web browser asked you if you were done viewing a web page every 2 minutes while surfing the web. Fun, yes?
Lastly, I encounter what I think could be the most useless alert message ALL THE TIME in SQL Server Enterprise Manager. When clicking on a SQL server to which I want to connect, I get this message EVERYTIME:
The Server /servername/ is not known to be running. Are you sure you want to try to connect to it?
HAHAHAHAHAHAHAHAHAHALOLOLOLOLOLOLROTFLMFAO!!!!!!!!!!
Trust me, if you don’t laugh about it, this message could make someone kill themselves.
OF COURSE the server isn’t known to be running. ANY NUMBER OF THINGS could have caused it to be unavailable. A power outage, system crash (which would be likely considering it is a Windows SQL server), network outage, earthquake, meteor strike, nuclear war…and on and on. Any of these things could cause it to be unavailable.
Tell you what Microsoft: I know this would be a stretch, but could you, maybe, try to connect to the server anyway….I know it may be a pile of rubble smoldering under the hot meteorite….and let me know if it is not available? Could you do this for me? Or maybe keep the error message, but change it to something just as useless like “The server IS KNOWN to be running. Are you sure you want to connect?” or “Peanut butter and honey sandwiches taste good to some people.” Either one would be just as helpful, granted the later one would be funnier.