Post reply

Trigger Problem

  • May 4, 2004 at 10:10 am

    #152132

    I have a table which includes a TEXT datatype column. I want to write an insert trigger on the table to place new records into an archive table for safekeeping.  When I checked the syntax, I received the error message 311

    "CANNOT USE TEXT, NTEXT, OR IMAGE COLUMNS IN THE INSERTED OR DELETED TABLES"

     

    Is there any workaround for this? It is vital that I have a mechanism to place all new records into another table as soon as they are written.

  • May 4, 2004 at 10:30 am

    #505164

    Found my answer in an INSTEAD OF INSERT trigger.

  • May 28, 2004 at 7:25 am

    #508191

    Hi,

     Please give me the answer

Viewing 3 posts - 1 through 2 (of 2 total)

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