Working With SQL Server Express

To manage Microsoft SQL Server 2005 Express Edition (SQL Server Express) databases, you must use both Transact-SQL and stored procedures. To perform the basic database tasks, see Overview of a Database. To perform advanced operations, see SQL Server 2005 Books Online.

This section refers to certain specific details about using SQL Server Express.

In This Section

This section contains the following topics:

Topic Description

Using the sqlcmd Utility (SQL Server Express)

Describes how to manage SQL Server Express databases from a command prompt.

Managing Database Files (SQL Server Express)

Describes how to install and preserve database files.

SQL Server Management Studio and SQL Server Express

Provides a brief overview to SQL Server Management Studio, which gets installed with all SQL Server 2005 editions except SQL Server Express. Describes how SQL Server Management Studio can be used to manage a SQL Server Express database.

Using Service Broker (SQL Server Express)

Describes the new Service Broker functionality in relation with SQL Server Express.

SQL Server Management Studio Express

Describes SQL Server Management Studio Express, a new tool that can be used to administer SQL Server Express database.

Reporting Services in SQL Server 2005 Express Edition with Advanced Services

Describes the various features of Reporting Services that are available with the SQL Server Express with Advanced Services edition.