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

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

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
>