I'm trying to do a simple 'replace value of' for an element in an XML
column whose XSD looks like:

[snip]



processContents="skip"/>



[snip]

I've tried using various syntaxes:

xmlEmail.modify('replace value of (/email/body/text())[1] with "

Task
has been assigned

"')

gives:

XQuery [@tblTasks.xmlEmail.modify()]: Result of 'text()' expression is
statically 'empty' (SQL error = 2377)

xmlEmail.modify('replace value of (/email/body)[1] with
xs:string("

Task has been assigned

")')

gives:

XQuery [@tblTasks.xmlEmail.modify()]: The target of 'replace value of'
must be a non-metadata attribute or an element with simple typed
content, found 'element(body,#anonymous) ?' (SQL error = 2356)

Does anyone know how to update this element?