validation-stored-procedure-master-data-services.md

title	Validation Stored Procedure
ms.custom
ms.date	03/01/2017
ms.prod	sql
ms.prod_service	mds
ms.reviewer
ms.technology	master-data-services
ms.topic	conceptual
ms.assetid	332d3c86-4440-4f12-a6cb-ffbfbccde52c
author	lrtoyou1223
ms.author	lle

Validation Stored Procedure (Master Data Services)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]

In [!INCLUDEssMDSshort], validate a version to apply business rules to all members in the model version.

This topic explains how to use the mdm.udpValidateModel stored procedure to validate data. If you are an administrator in the [!INCLUDEssMDSmdm] web application, you can do validation in the UI instead. For more information, see Validate a Version against Business Rules (Master Data Services).

Note

If you invoke validation before the staging process is complete, members that have not finished staging will not be validated.

Example

DECLARE @ModelName nVarchar(50) = 'Customer'   
DECLARE @Model_id int   
DECLARE @UserName nvarchar(50)= 'DOMAIN\user_name'   
DECLARE @User_ID int   
DECLARE @Version_ID int   
  
SET @User_ID = (SELECT ID    
                 FROM mdm.tblUser u   
                 WHERE u.UserName = @UserName)   
SET @Model_ID = (SELECT Top 1 Model_ID   
                 FROM mdm.viw_SYSTEM_SCHEMA_VERSION   
                 WHERE Model_Name = @ModelName)   
SET @Version_ID = (SELECT MAX(ID)   
                 FROM mdm.viw_SYSTEM_SCHEMA_VERSION   
                 WHERE Model_ID = @Model_ID)  
  
EXECUTE mdm.udpValidateModel @User_ID, @Model_ID, @Version_ID, 1  
  

Parameters

The parameters of this procedure are as follows:

Parameter	Description
UserID	The user ID.
Model_ID	The model ID.
Version_ID	The version ID.

See Also

Overview: Importing Data from Tables (Master Data Services)
Validate a Version against Business Rules (Master Data Services)