There are not many freeware alternatives to Microsoft’s SQL Server Management Studio. Fortunately, Quest Software has recently made their TOAD for SQL Server product freeware. I have used TOAD and other Quest Software products for Oracle in the past and I highly recommend using them.
The interface is much more intuitive and reacts smoother than SSMS and the clunky Server Explorer in Visual Studio. I can perform tasks such as stored procedure creation significantly faster with TOAD.