Is there anyway to be able to reference xml/text columns in the "inserted" and "deleted" tables in a SQL Server 2008 (CLR) trigger?

Question

I get an exception when I "Select * from deleted" in a clr trigger in SQL Server 2008. Is there anyway to be able to access xml/text columns from the deleted and inserted tables in a trigger?

score 1 · Accepted Answer · answered Jul 21 '09 at 16:22

1

convert your text and xml columns to varchar(max)

answered Jul 21 '09 at 16:22

Tigran

872
1
9
25

sorry should have been more descriptive. what you want can't be done. so best solution is to convert the xml column to varchar. this is a limitation of the system. – Tigran Apr 20 '10 at 23:12

Is there anyway to be able to reference xml/text columns in the "inserted" and "deleted" tables in a SQL Server 2008 (CLR) trigger?

1 Answers1