mdm.udpValidateModel can be run twice with no side effect.
I am new to MDS, client give me the mdm.udpValidateModel SP with @username etc. parameter. i don't know i parsed first time or executed.
I again executed. will there will be any side effect . please guide me urgently.
urgent.
SET @User_ID = (SELECT ID
FROM mdm.tblUser u
WHERE u.UserName = @UserName )
SET @Version_ID = (SELECT MAX(ID)
FROM mdm.viw_SYSTEM_SCHEMA_VERSION
WHERE Model_Name = @ModelName)
SET @Model_ID = (SELECT Model_ID
FROM mdm.viw_SYSTEM_SCHEMA_VERSION
WHERE Model_Name = @ModelName)
EXECUTE mdm.udpValidateModel @User_ID, @Model_ID, @Version_ID, 1
Manish
Software/Hardware used:
master Data Services sql server 2008 r2 mdm.validate model
Software/Hardware used:
master Data Services sql server 2008 r2 mdm.validate model
ASKED:
October 29, 2012 11:38 AM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
