RedGate has an excellent set of tools for working with MS SQL database servers (link).
XSQL has similar tools, with free lite versions (link).
SQL 2005 Service Manager (link) is a tool that sits in the tray and monitors SQL Server instances on local machine.
List of free SQL Server tools (link).
OpenDBDiff (link) - similar to SQL Compare, compares the database schemas.
DataScripter (link) - generates insert script for data in a table.