SQL Server Management Studio and SQL Server Management Studio Express (SQL Server Compact Edition)

  • Article

In Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition), you can access SQL Server Compact Edition databases stored on a smart device or on the desktop computer by using SQL Server Management Studio in SQL Server or SQL Server Management Studio Express (SSMSE). The SSMSE user interface is a subset of SQL Server Management Studio. SSMSE is a free download from the Web.

SQL Server Management Studio is a suite of administrative tools for managing the components that belong to SQL Server. This integrated environment allows users to perform a variety of tasks within a single interface, such as backing up data, editing queries, and automating common functions.

The following SQL Server Management Studio components integrate access to SQL Server Compact Edition objects and features:

  • Object Explorer—for locating, modifying, scripting or running objects in a SQL Server database.
  • Query Editor—for writing and editing scripts in SQL.
  • Template Browser—for locating and scripting templates.
  • Show Execution Plan—for viewing a graphical representation of a query's execution plan.

To use SQL Server Management Studio features with SQL Server Compact Edition, you must be familiar with SQL Server, SQL Server Compact Edition, and Transact-SQL, and you must have the following products installed:

  • SQL Server
  • SQL Server Compact Edition (included with SQL Server)
  • Microsoft ActiveSync
  • Microsoft .NET Compact Framework

In This Section

Topic Description

Querying SQL Server Compact Edition Database Data

Describes Query Editor, the language editor included in SQL Server Management Studio.

Locating and Scripting Templates

Describes templates, which let users easily create scripts for use with SQL Server Compact Edition databases.

Display Execution Plan for a Query

Describes using the Show Execution Plan command to see a graphical representation of the execution plan.