HOUR 3. Getting to Know the SQL Server Management Studio

The Microsoft SQL Server Management Studio Express is the new interface that Microsoft has provided for management of your SQL Server database. It is the main tool that you will use when maintaining your databases and the objects they contain. In this hour you’ll learn:

The system databases that ship with SQL Server 2005 Express

What is available under the Security node of the Management Studio

The types of server objects that are available

What is available under the Replication mode of Management Studio

What is available under the Management node of the Management Studio

How to create or attach to a SQL Server database

Microsoft SQL Server Management Studio Express

Management ...

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.