Post reply

Get around Text fields for Triggers

  • September 26, 2005 at 6:53 pm

    #91331

    I have an Accountmembership Table.

    This table has 5 TEXT (DataType) Columns. I'm currently developing Audit Triggers for this table. The problem I have is, that I cannot use TEXT, NTEXT in triggers because SQL Server does not support them in the INSERTED AND DELETED Tables.

    How do you get around this problem? Any one know?

    Kindest Regards,

  • September 26, 2005 at 11:43 pm

    #593170

    Use AFTER triggers and join from inserted back to the base table. I think you can access TEXT fields from the base table within the trigger, but not the "inserted" and "deleted" tables.

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

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