Home All Groups Group Topic Archive Search About

execute .exe from sql 2000

Author
19 Aug 2005 8:39 PM
atx
Hi,
I have a table where an application logs user events. I want to trigger or
execute another .exe from sql 2000 server when there is a new record in the
table. I want to execute/trigger the .exe for each new record, where .exe
arguments are the information written in some columns of the new record. for
example when a new record such as "user1, PC1, failed attempt" is written in
the table, sql 2000 will fire: "myprog.exe -u user1 -m PC1 -d "failed
attempt" " as the command....
pleasde help me on how to do it...
thanx,
atx

Author
19 Aug 2005 9:59 PM
GMG
The following article will explain how to execute a command line from SQL
2000:

http://www.mssql.com.au/kb/html/gmgxsl.dll/htmlkb?usexsl=y&sp=psearch_articl
e_text&@sa_id=61


Show quote
"atx" <a**@xerox.com> wrote in message
news:uiQvq4PpFHA.3316@TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a table where an application logs user events. I want to trigger or
> execute another .exe from sql 2000 server when there is a new record in
the
> table. I want to execute/trigger the .exe for each new record, where .exe
> arguments are the information written in some columns of the new record.
for
> example when a new record such as "user1, PC1, failed attempt" is written
in
> the table, sql 2000 will fire: "myprog.exe -u user1 -m PC1 -d "failed
> attempt" " as the command....
> pleasde help me on how to do it...
> thanx,
> atx
>
>

AddThis Social Bookmark Button