Narayana Vyas Kondreddi submitted "This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourslef, if you want to be a point-and-click DBA or a T-SQL scripting expert!"
Haven't read the above but using the gui doesn't allow you to save a record of what you have done so never use it for updates. Maybe for creating databases but I don't even do that.
For enquiries - maybe it is ok now - 6.5 it used to take locks so was pretty damaging to a production system. I use it for seeing if scheduled tasks are scheduled/running sometimes but that's about it. Sends a lot of data so not so good over a slow remote connection.
Do almost everything in a query window and if you are just looking at a production system make sure you execute set transaction isolation level read uncommitted first.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.