Are there alternatives to the TOAD tool for SQL Server? Are there any great tools as an alternative TOAD to be used for SQL Server?

The tool can be commerical or open source.
SQL Server Management Studio that comes with SQL Server?

If you need to run on non-Windows, then look at SQuireeL