How to manipulate TEXT, NTEXT data from sql server trigger

i hard that TEXT, NTEXT data can not be manipulated from sql server trigger. is it true. if not then please explain how could开发者_开发百科 i manipulate TEXT, NTEXT data from sql server trigger. thanks

Don't use text or ntext. Use nvarchar(max) or varchar(max)

Harsh, but they have been deprecated for a reason...

Edit, just remembered. You may be able to use INSTEAD OF triggers