|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
execute .exe from sql 2000Hi,
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 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 > > |
|||||||||||||||||||||||