• The short answer would be yes it's possible from a trigger, but it's not something I would allow any of my developers to implement. The risk of failed transactions and poor performanceis just too big.

    Why do you want a text file every time a record is inserted? Is this for auditing or do you need them as input for antoher system? In the latter case service broker might be the best option.

    Markus

    [font="Verdana"]Markus Bohse[/font]