Nice article - I voted 5 🙂

A few things I'dd add:

(1) check the server collation. Where I currently am DBA I have to standardise the collations across 20 servers because...

But in SQL Server 2005 the columns are NFR on the subscriber automatically so if the publisher identity range goes 1,2,4,5 then the subscriber also goes 1,2,4,5 ; ie the...

To be honest I'm not promoting the case for transactional replication as the best DR solution for all cases, so I don't necessarily disagree with you :). At my current...

Message for WherewasI: to be honest I'm not too sure of your configuration. Deadlocks on the publisher won't bother the subscriber as only committed transactions are replicated. Perhaps the deadlocks...

Transactional replication is considered by MS as a DR solution and is part of the High Availability set of Technet articles. Really there isn't really a one-size-fits-all here in the...

Ok - there are various considerations for BLOBS eg updates have to be done in a transaction and the textptr retreived in the same transaction and max text repl size...

Brandon,

all due respect but I think you're missing the point.

Judging by some of the questions, some others (Jeff apart) have also never really tried to solve this problem in...

Just to clarify - the "hour or so" being referred to was the time taken to create the package.

Rgds,

Paul Ibison

Thanks Jeff. The name makes sense but I can find no reference to it. Can you provide a link to the "mixed rowtype" definition (search for "mixed rowtype" in Google...

I looked at the conditional split, but if you have >50 columns (as I have), you'll need to manually define each column - that means define the name and write...

OK - I was hooked into thinking that the buffers were changing the order, but as you rightly point out in the absence of a clustered index on the table,...

Hi Jim,

that's reassuring in a sense that my cautious approach was OK:)

BTW we're talking about reading from a text file rather than a table.

Even so I'm still a little mystified...

True - the title is a little misleading. The problem is that there isn't a 'correct' term for such files and this is the nearest commonly understood one. Anyway, what...