In this case, they are all coming through the same client which is the application web server. And the data is just fine in our production server - it just...

I just did, and no problems were found

Correct,

In all the cases I've seen, they're SP calls that simply use the UPDATE statement to update the NTEXT values from the value passed in the parameter. I see consequent...

The problem seems to happen randomly on multiple tables, only on some updates where the NTEXT field is updated (some updates come across ok). No errors are logged by the...

It's set to 65536. The string in question is <32 bytes long.

I have also confirmed that the commands in the distribution database have the "corrupted" values by using sp_browsereplcmds

Here's the schema_option value I use in my setup - hope it's helpful

SET @schema_opt = 1 | 2 | 16 | 32 | 64 | 128 ...

Thanks for the link. It does explain what's going on in this case - however the deadlock graph is not showing the 2nd lock in question. Maybe it's a limitation...

By the way - the same issue occurs if a view is used instead of the subquery.

Does anyone know which specific hotfix fixed this issue?

http://www.codeproject.com/sqlrs/PDFUsingSQLRepServices.asp should help you get started

You could create a report that takes the customer number as a parameter, then have your application call this report for different customers and generate PDFs. Your application could pretty...

Are both pcs on the same/trusted domain as the server? I've seen this problem when the server and the client were on different untrusted domains.

You can use rs.exe to script the copying, see books on line or here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rs_v1_5fxe.asp

It does work in HTML, but not in a report. Like I've said in my original post, it just removes the hyperlink alltogether when I have a , or ;...

Can you provide more deatils? Are you calling the report service from an ASP.NET page?