Programacion

Managing SQL Server Express with SQL Server 2005 Management Studio Express Edition
SQL Server Technical Article Writers: Eric Brown, Senior Consultant Quilogy Inc.

Published: March 2006 Applies To: SQL Server 2005 Summary: Learn how to manage SQL Server 2005 Express Edition by using the free graphical management tool, SQL Server 2005 Management Studio Express Edition (SSMSE). Developers andadministrators will learn how to use SSMSE features to simplify, automate, and reduce the complexity of database support and administration.

Prerequisites:
SQL Server 2005 Express Edition SQL Server 2005 Management Studio Express Edition November CTP

Copyright
This is a preliminary document and may be changed substantially prior to final commercial release of the software described herein.The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.This White Paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.

Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any formor by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft,the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

Unless otherwise noted, the example companies, organizations, products, domain names, e-mail addresses, logos, people, places and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, emailaddress, logo, person, place or event is intended or should be inferred.

© 2006 Microsoft Corporation. All rights reserved.

Microsoft, Visual Studio, and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Tableof Contents
An Introduction to SQL Server Management Studio Express Edition .................1 Getting started ...............................................................................................1 Connecting to servers ......................................................................................1 Organizing your database servers.....................................................................2 Making the most of Object Explorer ...................................................................3 Creating a database ........................................................................................4 Creating tables ...............................................................................................5 Creating a database diagram............................................................................5 Creating a view...............................................................................................5 Writing scripts by using the Query Editor ...........................................................5 Understanding basic query syntax .....................................................................5 Using Template...