Murach's SQL Server 2005 for Developers
How to use the Management Studio

This chapter presents the SQL Server Management Studio, the primary tool you'll use to work with with SQL Server databases.
Chapter 2 How to use the Management Studio
An introduction to SQL Server 2005 48
A summary of the SQL Server 2005 tools 48
How to start and stop the database engine 50
How to enable remote connections 50
An introduction to the Management Studio 52
How to connect to a database server 52
How to navigate through the database objects 54
How to manage the database files 56
How to attach a database 56
How to detach a database 58
How to back up a database 58
How to restore a database 58
How to set the compatibility level for a database 60
How to view and modify the database definition 62
How to view the database diagrams 62
How to view the column definitions of a table 64
How to modify the column definitions 64
How to work with queries 66
How to enter and execute a query 66
How to handle syntax errors 68
How to open and save queries 70
An introduction to the Query Designer 72
How to use Books Online 74
How to start Books Online 74
How to look up information 74
Perspective 76
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.