| title | Reactivate a Member or Collection | ||||||
|---|---|---|---|---|---|---|---|
| description | Reactivate a Member or Collection (Master Data Services) | ||||||
| author | meetdeepak | ||||||
| ms.author | dkhare | ||||||
| ms.reviewer | mikeray | ||||||
| ms.date | 03/05/2026 | ||||||
| ms.service | sql | ||||||
| ms.subservice | master-data-services | ||||||
| ms.topic | how-to | ||||||
| ms.custom |
|
||||||
| helpviewer_keywords |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
[!INCLUDE support-notice]
In [!INCLUDEssMDSshort], you can reactivate a member that was either:
-
Deactivated by the staging process.
-
Deleted in the MDS [!INCLUDEssMDSXLS].
-
Deleted in the [!INCLUDEssMDSmdm] web application.
When you reactivate a member, its attributes and its membership in hierarchies and collections are restored.
You can also reactivate collections. When you do, the collection's attributes and the members that belong to the collection are restored.
When either a collection or member is reactivated, all previous transactions are restored.
To perform this procedure:
-
In [!INCLUDEssMDSmdm], you must have permission to the Version Management functional area.
-
You must be a model administrator. For more information, see Administrators (Master Data Services).
-
On the [!INCLUDEssMDSmdm] home page, click Version Management.
-
On the menu bar, click Transactions.
-
On the Transactions page, from the Model list, select a model.
-
From the Version list, select a version.
-
In the Transactions pane, click the row for the member or collection you want to reactivate. This row should have Active displayed in the Prior Value column and De-Activated in the New Value column.
-
Click Reverse Transaction.
-
On the confirmation dialog box, click OK. A new transaction is added, showing Active in the New Value column.
Delete a Member or Collection (Master Data Services)
Members (Master Data Services)
Collections (Master Data Services)