Error 311 Cannot use text ntext or image columns in the inserted..

[EnemyGateIsDown]

Hi chaps..

I am trying to implement a simple trigger to arhive a record when it is deleted to a table which is a copy of the source table. However the source table contains ntext items. When i try to compile the trigger i get the following error:

Error 311: Cannot use text, ntext or image columns in the inserted and deleted tables.

As the Source table is fixed by the application, I can't do much to change data types.

Does anyone know how I can get around this?

Any help is as always greatly appreciated.

Cheers,

Chris

 

[psprague]

Binary types such as text, ntext and images are not allowed in an 'after' trigger but they are acceptable in an 'instead of' trigger.