Reg: Handling Text Column in Trigger implementation

[User 4005525]

Hi, I'm trying to create a trigger for a table which has a column of type TEXT. While executing Trigger Statement, It shows a message stating that " can't use text field in inserted/deleted table". Can anyone give me the solution for this problem? Thanks in advance sri

[Wendelius]

Hi, If possible use VARCHAR(MAX) instead of TEXT data type. TEXT should not be used anymore. If not possible, use INSTEAD OF trigger. Normal AFTER trigger does not support TEXT datatype. Hope this helps, Mika