Post reply

text field in insert trigger

  • July 29, 2009 at 10:12 am

    #93931

    Hi All,

    I've a text datatype column in a table. I would like to create an insert trigger on that table.

    When i do it i'm receving the following error.

    'Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.'

    Can someone tell me how to handle this situation.

    Thanks in advance!

  • July 29, 2009 at 10:18 am

    #1031855

    Move to varchar(max) as a data type.

  • July 29, 2009 at 10:31 am

    #1031866

    Hi thanks for ur reply.

    Do we need to change the datatype in the table.

    If so isn't there a work around for that so as to access that field in the INSERTED table without changing the datatype in the table??

  • July 29, 2009 at 12:15 pm

    #1031940

    I don't believe there is a workaround. The CREATE TRIGGER documentation says not text/ntext types.

    What are you trying to accomplish?

  • July 29, 2009 at 2:09 pm

    #1032010

    Hi,

    I'm just trying to get the Value that is being inserted into the column of datatype 'TEXT' into a variable and send an email notification saying that this value has been inserted into the table.

Viewing 5 posts - 1 through 4 (of 4 total)

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