Execute external command in SQL 2000

Is there a way to execute an external command in SQL 2000. For SQL 2005 I
found the xp_cmdshell procedure.
Thanks,Tim Kelley wrote:
> Is there a way to execute an external command in SQL 2000. For SQL 2005 I
> found the xp_cmdshell procedure.
> Thanks,
>
xp_cmdshell exists in SQL 2000 as well.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The xp_cmdshell procedure is available in SQL Server 2000 as well.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"Tim Kelley" <tkelley@.company.com> wrote in message
news:OtZrgipLHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Is there a way to execute an external command in SQL 2000. For SQL 2005 I
> found the xp_cmdshell procedure.
> Thanks,
>|||Hello,
Use XP_CMDSHELL. This extended procedure is available in Master database in
SQL 2000.
Master..xp_cmdshell 'dir c:\'
Ensure that you are not executing any looping commands or any commands with
high stress using XP_CMDSHELL.
Thanks
Hari
"Tim Kelley" <tkelley@.company.com> wrote in message
news:OtZrgipLHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Is there a way to execute an external command in SQL 2000. For SQL 2005 I
> found the xp_cmdshell procedure.
> Thanks,
>