I'm trying to write a trigger that will store the inserted and deleted tables in a couple of varchars (in xml)
and then call something to insert into an audit table.

declare @temp table(v varchar(4000))
INSERT INTO @temp
SELECT *
FROM TblCust
FOR XML RAW

This doesn't work as I know you cant use FOR XML RAW
with an insert statement. Anyone have any ideas?

Thanks.
John