Microsoft SQL Server forum - How to execute a "batch file" using SQL Server 2005?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to execute a "batch file" using SQL Server 2005?

coosa

2005-12-23, 9:23 am

Hi all,

As the topic describes, I'd like to run a batch file using sql server.
How do i do it?

Thanks in advance

Dan Guzman

2005-12-23, 9:23 am

One method is with a SQL Server agent CmdExec job step. Another is via
xp_cmdshell. If you choose to use xp_cmdshell, be sure you fully understand
the security implications and don't grant direct execute permissions on the
proc.

--
Happy Holidays

Dan Guzman
SQL Server MVP

"coosa" <coosa76@gmail.com> wrote in message
news:1135346052.206276.14220@o13g2000cwo.googlegroups.com...
> Hi all,
>
> As the topic describes, I'd like to run a batch file using sql server.
> How do i do it?
>
> Thanks in advance
>

Sponsored Links