>If I try this...
>
>INSERT INTO MyTable_tmp SELECT * FROM Inserted
>
>I got the following error... (on the check syntax)
>Error 311: Cannot use text, ntext or image columns in the 'Inserted' and 'Deleted' tables.
The error is strange, but what is the structure of MyTable_tmp?
If it's not broken, fix it until it is.
My Blog