tMDMSP

Avoid the use of tMDMSP when you can

tMDMSP, and the use of Stored Procedures in general should be avoided.

For portability reasons, only use SP when what you want to do isn't possible at all with the standard components, because Stored Procedures may make your Job dependent to a particular persistence layer.

Hence, your Stored Procedures (and maybe the Jobs that are calling it) will need to be rewritten when migrating from one persistence layer to another.