• anujkumar.mca - Tuesday, December 26, 2017 9:13 AM

    enable the XP_CMDShell at prod shall not be recommended

    Heh... I suppose you think that it somehow makes your server more secure to not enable it?  That's a very frequent but incorrect assumption. 😉

    That, not withstanding, you don't need to use xp_CmdShell for this... you could use a CmdExec step or you could do it from a good ol' fashioned batch file.

    Or you could use that "Maintenance Plan" method I previously mentioned to fan out the work.

    Understood on the "gotta try it" thing you speak of.  I agree.  You won't know for sure unless you try.  As a good friend and fellow denizen of this site once told me, "A Developer must not guess... a Developer must KNOW" and trying it is about the only way to know for sure.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)