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)

 

Applies To: SQL Server 2016 Preview

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.

System_CAPS_warningWarning

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

Prerequisites

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.

    System_CAPS_noteNote

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

Community Additions

ADD
Show:
© 2015 Microsoft