Sdílet prostřednictvím


Introducing SQL Server Management Studio

Microsoft SQL Server Management Studio, new in Microsoft SQL Server 2005, is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SQL Server Management Studio combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators of all skill levels.

SQL Server Management Studio combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. In addition, SQL Server Management Studio works with all components of SQL Server such as Reporting Services, Integration Services, SQL Server 2005 Compact Edition, and Notification Services. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

To access SQL Server Management Studio

  • On the taskbar, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

Note

By default, SQL Server Management Studio is installed in C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.

Note

SQL Server Management Studio presents dates formatted with the Microsoft Windows Regional and Language Options in effect when SQL Server Management Studio was started. Restart SQL Server Management Studio to reflect newer settings.

With SQL Server Management Studio, the database developer and administrator can develop or administer any of the components of the Database Engine.

In This Section

See Also

Other Resources

SQL Server Management Studio How-to Topics
How to: View Server Properties (SQL Server Management Studio)
How to: Connect to SQL Server from Windows Vista

Help and Information

Getting SQL Server 2005 Assistance