Running DOS Command Prompt(cmd) command thought SSMS

  • naveenreddy.84 (10/1/2009)


    Its a local drive!!!

    Heh... local to what? Your workstation or the server?

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

  • Also - keep in mind that this may not be running under your credentials. Depending on circumstances or version, you may need to check that the following user accounts have access to the executable, from the context of the server:

    - the SQL service account

    - the SQL Server Agent service account

    - the xp_cmdshell proxy user account

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • Local to the server!!!

  • Then like Matt Miller is saying, whatever login the server is using, it doesn't have privs to the file. Find out what login the server is using and see if it has the necessary privs.

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

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply