Posted by mcolson on 08/09/07 21:23

On Aug 9, 1:26 pm, Roy Harvey <roy_har...@snet.net> wrote:
> You can look at xp_cmdshell. Note that no program run that way can
> open any sort of window, or prompt the "user" for anything at all.
>
> You may also want to look into running it as a job.
>
> Roy Harvey
> Beacon Falls, CT
>
> On Thu, 09 Aug 2007 15:44:36 -0000, mcolson <mcolson1...@gmail.com>
> wrote:
>
> >Is it possible to use sql to execute a batch file? I would like to
> >execute the following "C:\BTW\bartend.exe /f=C:\BTW\Toolbox\Formats
> >\carnum.btw /p", 6
>
> >Thanks,
>
> >Matt

When I use the xp_cmdshell to try and run the bat file, i get an
output saying access denied. It should be noted that I am using sql
server 2005 express. Is this why. When I try to copy the file to
another location, i get 0 copied. I am able to dir the directory just
fine.

[Back to original message]