Programs I use for managing MS SQL databases:
Enterprise Manager - Building Database, Views, Stored Procedures, etc.
MS Access (adp file) - access tables and for copying and pasting data
Web Interfaces - played with
myLittleTools, web-based tools for SQL Server professionals and asp.net enterprise manager. Grand for looking at database and making small changes but neither compares to Enterprise Manager. Although, mylittletools has a new version since I last used it and it looks quite neat I must say.