Trigger Advice

[scohan]

After a row is inserted to a specific table, I need to go open an XML file (whose name is determined using a column value from this row), move to a certain line in the file containing a value of interest, take that value and insert it back into a column in the newly created row.

I'm trying to decide if I should do all of this using a trigger, or if should I use the trigger to call something like a VB executable.

I'm using NT 4.0 and SQL server 7. I'm more familiar with Unix, Oracle and C but can handle this environment. Any implementation suggestions/alternatives would be greatly appreciated. Thanks.

 

[Cagliostro]

It depends of your program's interface. MSSQL7 does not work directly with XML.
I think, your program should at the first opent the XML file, read data and insert. Triggers there are not aplicable.