SQLManager.net has developed the greatest SQL Manager I've ever used. It kills the SQL IDE's that come with both SQL 2000 and 2005 (Enterprise Manager). One of the biggest features for me is that it lets you connect to both SQL Server 2000 and 2005. Best of all - there is a freeware version available! I'm not sure what features are missing in the freeware version as I'm using the 30 day free trial.
Anyhow - enjoy!
EMS SQL Manager for SQL Server
http://www.sqlmanager.net/en/products/mssql/manager