Post reply

Generating a text file

  • September 9, 2005 at 1:35 pm

    #588885

    Why a text file?

  • September 9, 2005 at 1:35 pm

    #89022

    Hi, dear

    Is it possible to create a trigger that generate a text file when inserting, deleting, updating?

    Thank you very much

    Obede

  • September 9, 2005 at 1:41 pm

    #588888

    A windows service searches for files on a directory each 1 hour.

    When this windows service find the text file, it executes a process.

  • September 9, 2005 at 1:50 pm

    #588891

    Why not make the server generate that file 2 minutes before the service starts?

  • September 9, 2005 at 2:07 pm

    #588900

    I need to execute a process when inserting, updating or deleting.

  • September 9, 2005 at 2:11 pm

    #588902

    No you don't need to, you can flag the new rows and have a job send the information to a text file when needed, which is the recommended method of doing that.

  • September 10, 2005 at 11:00 pm

    #588970

    I've gotta agree with Remi on this one... make the trigger mark the records or even save the records in a different table.  Then, have your scheduled job run a little OSQL to create the file.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply