Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Delete a Version (Master Data Services)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

In Master Data Services, delete a version when you are sure you no longer need the master data associated with the version. After you delete a version, you cannot retrieve the associated master data.

Caution note Caution

If a model has only one version and you delete it, the model becomes unusable.

To perform this procedure:

  • You must have permission to view the mdm.viw_SYSTEM_SCHEMA_VERSION view and to execute the mds.udpVersionDelete stored procedure in the Master Data Services database. For more information, see Database Object Security (Master Data Services).

To delete a version

  1. Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.

  2. Open the mdm.viw_SYSTEM_SCHEMA_VERSION view.

  3. Find the version of the model you want to delete and copy the value in the ID field.

  4. Create a new query.

  5. Type the following text, replacing version_ID with the value you copied in step 2.

    EXEC [mdm].[udpVersionDelete] @Version_ID='version_ID'
  6. Run the query.

    Note Note

    You may have to wait a few minutes before the Web application reflects the change.

Community Additions

© 2015 Microsoft