tilew-948340 (10/8/2012)Just to let you know that also some people reading the QotD might never use anything else then the SSMS because... well... not every one is a professionnal in SQL server.
For the record: I never intended my message to imply that I don't use SSMS, just that some people don't. For most SQL Server professionals, SSMS is the tool of their trade.
p.s. by the way, with what do you work if you don't use SSMS?
I use SSMS for most of my interactive work (querying, checking results, changing query, etc).
But I also save scripts to my filesystem and then execute them using sqlcmd.exe (I have an icon on my desktop that I can just drag&drop a script on - it will automatically fire sqlcmd.exe, execute the script, save the results in a file, then open Notepad when the results). Most people will not create objects in such scripts, but since my main job is to write a T-SQL code generator, my scripts usually contain lots of code to create, drop, or alter database objects.
Other tools that are not used by me (but may be frequently used by others) are SSIS (to create tables to hold imported data), and homebrewn .Net applications.