Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables in triggers

See more:

SQL-Server-2005

SQL-Server

Hello All
I have trigger that does not work if i have "text" as datatype.

create TRIGGER [dbo].[UpdateAssetDeleteLog]
   ON  [dbo].[asset_device] 
   AFTER DELETE
AS 
BEGIN
		DECLARE @device_name varchar(500)
		DECLARE @device_ip_address varchar(100)
		DECLARE @device_type varchar(100)
		DECLARE @device_desc varchar(8000)
		DECLARE @first_discovered datetime
		DECLARE @last_discovered datetime
		DECLARE @asset_profile_id int
		DECLARE @deleted_by_user int

		DECLARE  CUR_DELETED 
		CURSOR FOR 
		SELECT asset_device_name,
		asset_device_ip_address, 
		asset_device_type [Device Type],
		asset_device_desc,
		asset_device_first_discovery,		
		asset_device_last_discovery AS [Last Discovered],
		asset_profile_id
		
		
		FROM deleted
		
        OPEN    CUR_DELETED
		FETCH FROM CUR_DELETED INTO @device_name,@device_ip_address,@device_type,@device_desc,@first_discovered,@last_discovered,@asset_profile_id
		
		WHILE (@@FETCH_STATUS = 0)
        BEGIN
		INSERT INTO dbo.asset_deleted_device_detail
		(
			[device_name],
			[device_ip_address],
			[device_type],
			[device_desc],
			[first_discovered],
			[last_discovered],
			[asset_profile_id],
			[deleted_by_user],
			[deleted_date]
		)
		VALUES
		(	
			
			@device_name,
			@device_ip_address,
			@device_type,
			@device_desc,
			@first_discovered,
			@last_discovered,
			@asset_profile_id,
			1,
			getdate()
		 )

		FETCH FROM CUR_DELETED INTO @device_name,@device_ip_address,@device_type,@device_desc,@first_discovered,@last_discovered,@asset_profile_id
			
        END
        CLOSE CUR_DELETED
		DEALLOCATE CUR_DELETED

END

The error message is like this.
Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables

Can anyone help me?

Regards
Jesu