Trigger to file

[fcela]

Hi!

I need help with syntax:

CREATE TRIGGER to_file ON TABLE
FOR INSERT
AS
-- wher is insert to table -->> row will be direct to file etc.: C:\\TEMP\log (txt file???)

Thanks for help with syntax.

[rmiao]

Try call bcp with xp_cmdshell in the trigger.