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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.