Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The topics in this section provide information about how to perform tasks related to the SQL Server 2005 Database Engine by using SQL Server Management Studio, Transact-SQL, SQL Server Configuration Manager, SQL Server Profiler, command-prompt utilities, and other tools and wizards.
In This Section
| Topic | Description |
|---|---|
How to create databases, database snapshots, and indexes. |
|
How to manage services, configure availability, back up and restore databases, manage servers and server connectivity, and configure clients. |
|
Automated Administration How-to Topics (SQL Server Management Studio) |
How to define jobs and alerts in SQL Server Management Studio. |
How to define jobs and alerts with Transact-SQL stored procedures. |
|
How to monitor SQL Server performance and user activity, tune the design of databases for optimal performance, and view query execution plans. |
|
How to use the Visual Database Tools Database Designer, Table and View Designer, and Query Designer. |