Murach's SQL Server 2008 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 2008 48
A summary of the SQL Server 2008 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 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 view the data of a table 66
How to modify the data of a table 66
How to work with queries 68
How to enter and execute a query 68
How to handle syntax errors 70
How to open and save queries 72
An introduction to the Query Designer 74
How to use Books Online 76
How to start Books Online 76
How to look up information 76
t


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

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



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.