SSMS all the way.  Every other IDE I have tried had some nice features that made me want to use it, but they all also lacked several important things that...