Probably that UDFs can't create temp tables, nor can they run dynamic SQL.

L' Eomot Inversé (12/15/2011)

---

WayneS (12/15/2011)

---

Alternative workaround: notice how many posts you are off, then go down that many posts and click the quote button on that post. (But it won't...

Another possibility occurs to me:

Most "illegal XML character" errors I've run into have been ampersands ("&"). A few have been brackets. Since it's nvarchar(max), you can:

select *

from dbo.MyTable

where...

Your table has multiple rows of nvarchar(max), and one or more of those have an illegal XML character in them. Correct?

Can you step through the table, assign that column...

It does not use SQL Server Database Mail.

It does use SMTP. But so does Database Mail. SMTP is simply the mail transfer method ("Simple Mail Transfer Protocol" is...

Definitely not an SQL Server issue. Code.

That's exactly what Merge is for.

You re-write the stored procedure to use Merge instead of Insert, test it, and it should do exactly what you need.

Just make sure to do...

I'm not clear enough on the data structure you're dealing with.

You don't have to link a table to every other table with a matching column. Are you trying to...

What you're asking about is what's called an "upsert". In other words "update if existing, insert if not".

In SQL 2008, you can use the "Merge" command to do this....

I'm not familiar enough with Dynamics databases specifically to say yes/no on what you're doing.

However, the basic practice of what you're doing looks sound. Do that in a CTE...

It doesn't use sp_send_dbmail if that's what you mean.

The first question, of course, is do you have access to the code to fix anything if you do find the problem?

Some proprietary, third-party software, even when you find a...

PaulB-TheOneAndOnly (12/15/2011)

---

You are...

Are you storing XML in a string datatype (varchar is the most common for that), and then trying to use an XML function on it or put it in an...

You're going to want to break that up into smaller transactions no matter how you deal with it, or your transaction log is going to explode.

What form is the data...