Using SQL Server Management Studio
SQL Server Management Studio is an integrated utility you use to manage the database engine, analysis services, integration services, reporting services, and SQL Server mobile. It is the main tool you use as a DBA to manage your SQL Server instances on a daily basis.
It replaces the myriad of tools that were available in early versions of SQL Server. Watch for future "add-ons" such as the Microsoft Visual Studio 2005 Team Edition for Database Professionals, which will help develop databases in a managed project environment with support for deployment, off-line development, refactoring, unit testing and versioning.
SQL Server Management Studio Environment
Since SQL Server Management Studio environment is based on ...