Brian Donahue wrote:I'm trying to reproduce this - what is the problematic BLOB type (image, text, binary), version of SQL Server, and the size of BLOBS going in?
It doesn't seem to use or need the pointer for nvarchar(max) on SQL 2008, but it does declare @pv again in every block of split transactions.
Brian Donahue wrote:How do you re-use the scripts? Are you running them in another tool, like sqlcmd?
Brian Donahue wrote:My thought is, that if it works in SQL Data Compare but not from sqlcmd, perhaps there is some option you can change in sqlcmd? I'm not sure how sqlcmd deals with batches and transactions.
Users browsing this forum: No registered users and 0 guests