Post reply

xp_cmdshell help!

  • April 13, 2007 at 12:33 pm

    #116910

    Hi All,

    I have a bat file that works just fine if I execute it manually.  However, if I want to use xp_cmdshell to run it, it did not work for me at all:

    exec master..xpcmdshell 'e:\data_dump\automate_mail.bat'

    It gave me error: E was not reconized as internal or external function.

    Did I miss anything.  Please help.

    Thanks a million,

    Minh Vu

     

  • April 13, 2007 at 1:21 pm

    #700498

    Does the SQL Server have an "e:" drive, and if so, does it have that file in that path? Your best bet is to use UNC naming, and to place that file somewhere that the server can see it.

     

  • April 13, 2007 at 3:34 pm

    #700524

    Yes, the E is my local SQL Server drive that I have in my system.

    Thanks,

    Minh Vu

Viewing 3 posts - 1 through 2 (of 2 total)

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