Share via


SQL Server Modeling Services Administration

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

The SQL Server Modeling Services database contains built-in services and design features that require administration. The topics in this section focus on some of the most common Modeling Services administration tasks.

Modeling Services Administration Overview

At this time, administration tasks require direct queries and store procedure calls to the Modeling Services database. The Modeling Services database is designed to provide open and flexible access for secured users and applications. The tasks in this section provide instructions and T-SQL examples. You can use any tool or data access technique to perform the tasks. SQL Server 2008 ships with two tools that can be used for these tasks. The Microsoft SQL Server Command Line Tool, SqlCmd.exe, provides the ability to run queries from the command prompt. Microsoft SQL Server Management Studio is a graphical tool with a rich user interface for creating tables, changing data, managing permissions, and many other tasks. Users also can open a query window to directly run T-SQL commands to perform the same actions. Most of the administration tasks in this section use Microsoft SQL Server Management Studio, but you can use other database tools, such as Sqlcmd.exe, depending on your preference.

Note

Unless otherwise stated, the tasks described in this section require the user to belong to the RepositoryAdministrator role.

In This Section

The following topics describe common Modeling Services administrative tasks:

See Also

Concepts

SQL Server Modeling Services Overview
SQL Server Modeling Services Architecture
SQL Server Modeling Services Design Patterns