Procedures (Repository Schema)
[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 Repository schema contains the following procedures.
Procedures
| Procedure | Description |
|---|---|
Creates a Modeling Services database login and user, assigning the new user to the specified Modeling Services role. |
|
Creates a named sequence object that obtains one or more valid identifiers for newly inserted rows. |
|
Creates an alias for a sequence object that can be used to provide unique identifiers across multiple views or tables. |
|
Raises a SQL Server error message. This procedure is called by other Modeling Services functions and procedures. |
|
Initializes a SQL Server instance to support the Modeling Services database. This must be called once for Modeling Services databases that are moved to new SQL Server instances. |
|
An infrastructure routine that formats an error string with the provided values and then raises a SQL Server error with the formatted message. |
|
Returns one or more unique identifiers for the given sequence object or sequence alias. |
|
Raises a SQL Server error message for a Modeling Services error event. |
|
Raises an error when a Modeling Services constraint is violated. |
|
Raises an error when a Modeling Services procedure is called with an incorrect parameter value. |
|
Raises an error when there is an attempt to change a read-only column in a Modeling Services table. |
|
Raises an error when a subset constraint is violated. A subset constraint specifies that the values in one column must be a subset of those in another column. |
|
Raises an error when a subset constraint is violated. A subset constraint specifies that the values in one column must be a subset of those in another column. Unlike the [Repository].[RaiseErrorSubsetConstraintViolated] procedure, this procedure is used for subset constraints that involve multiple columns. |
|
Raises an error when a unique constraint is violated on a column. The unique constraint specifies that all values for a given column must be unique. |
|
Raises a SQL Server warning message for a Modeling Services warning. |
|
Removes a Windows principal from accessing the Modeling Services database. |