Toad® for SQL Server
"Toad® for SQL Server is a freeware tool that improves the productivity of developers and administrators by providing an easy-to-use development environment for T-SQL code."
Been around for awhile, this is a great tool -- a must for SQL Server DBA's and developers. Stored procedure version control, lots of automation...
Fully functional 60 day eval version available under Software Downloads.