Home Forums SQL Server 2012 SQL Server 2012 - T-SQL BCP through XP_CMDSHELL not responding RE: BCP through XP_CMDSHELL not responding

  • October 9, 2013 at 3:51 pm

    #1657331

    Can you post the xp_CmdShell call that you're using, please? I have a couple of ideas on the problem but I need to see that command. If it's not a trusted connection please replace the user name and password with "username" and "password" respectively. You can also replace the server name with "servername" if it makes you nervous to have that info out there.

    --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)