Post reply

Running DOS Command Prompt(cmd) command thought SSMS

  • October 2, 2009 at 12:15 pm

    #1061113

    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)
    Intro to Tally Tables and Functions

  • October 2, 2009 at 12:21 pm

    #1061116

    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?

  • October 2, 2009 at 12:24 pm

    #1061117

    Local to the server!!!

  • October 2, 2009 at 12:33 pm

    #1061122

    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)
    Intro to Tally Tables and Functions

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

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