This topic has not yet been rated - Rate this topic

Reserved Words (Master Data Services)

SQL Server 2012

SQL Server 2008 R2

In Master Data Services, when you create model objects or members, some words cannot be used. Using these words may cause errors.

Note
You should also limit your use of special characters (symbols, hyphenation, etc.).

Models

If you create a model with the name set to Name, do not select Create entity with same name as model because Name cannot be used for the name of an entity.

Entities

For entity names, you cannot use Name or Code.

Explicit Hierarchies

For explicit hierarchy names, you cannot use Name or Code.

Attributes

ID
Code
Name
EnterDTM
EnterUserID
EnterUserName
LastChgDTM
LastChgUserID
Status_ID
ValidationStatus_ID
Version_ID

Members

For members, you cannot use MDMMemberStatus or ROOT for the Code attribute value.

Concepts

Master Data Services Overview

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD