>>>> The error is strange, but what is the structure of MyTable_tmp?
>>>It's because MyTable_tmp contains two columns of 'text' type?
>>
>>Yes, I would guess so. May be you need to list all fields you want to insert explicitly.
>
>From BOL:
>
>SQL Server 2005 does not allow for text, ntext, or image column references in the inserted and deleted tables for AFTER triggers. However, these data types are included for backward compatibility purposes only. The preferred storage for large data is to use the varchar(max), nvarchar(max), and varbinary(max) data types. Both AFTER and INSTEAD OF triggers support varchar(max), nvarchar(max), and varbinary(max) data in the inserted and deleted tables.
What would you do if you convert your database from SQL Server 2000? You may have text fields in your tables.
Also note the SQL Server version in the message version. Looks like Marc is using previous version...
If it's not broken, fix it until it is.
My Blog