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 ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.