Home Forums SQL Server 2005 Administering execute xp_cmdshell - cant get it to work - no matter what - any one? RE: execute xp_cmdshell - cant get it to work - no matter what - any one?

  • May 6, 2015 at 8:03 pm

    #1796099

    Lynn Hendricks (5/6/2015)

    Well your suggestions worked.

    After I was going to post the DDL, I noticed an error in the SQL statement.

    And as I fixed that, the xp_cmdshell to create the file worked.

    So now I need to figure out, out of all the steps I tried. To back out and then put in the basics.

    And have the proc execute as owner, and give the proc execute permissions to the role that is running from the application.

    Your steps worked. thank you so very much.

    thanks again.

    Thanks for the feedback, Lynn. Glad it's working. The first time I ever did it, it drove me nuts.

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