So the table is a heap (no clustered index), there are no unique constraints whatsoever, yet you get an error inserting a duplicate row...Can you please post the exact DDL...

I've tried every version of the code pasted on the page and consistently get this error:

Msg 9436, Level 16, State 1, Line 1

XML parsing: line 5, character 15, end tag...

Thanks so much it's for the additional feedback in this, I will test out the CLR code to see if I'm gaining any advantage over the tally table method! ...

While I am not 100% sure, I've always under the impression that procedures that had WITH RECOMPILE on them didn't retain the execution plans...

That's a very good question and in all honesty I don't know...I believe there's a uid (row guid/unique identifier) that is assigned to each row...but I'll have to check with...

MyDoggieJessie (6/7/2012)

---

Would soemthing like this work, or is it defeating the purpose of Jeff's work of art?

CREATE FUNCTION [dbo].[fx_SplitExtents]

(

...

Would soemthing like this work, or is it defeating the purpose of Jeff's work of art?

CREATE FUNCTION [dbo].[fx_SplitExtents]

(

...

The number is the position, and the value can be 1-80 for some fields, 1-40 in some, and 1-20 in others

Ex:

dbo.SplitCMD([ts-fee-amt],80)

Check out this link: http://blogs.msdn.com/b/john_daskalakis/archive/2009/11/13/9921916.aspx

I've had this happened before (not with the JDBC drivers) and the cause could relate to your issue as well.

Make sure the temp tables are dropped. when you first executed the script the temp tables were created then when you attempted to rerun it, it fails because that...

jei33 (5/18/2012)

---

Nice article, thanks.

Question:

if you have detected that huge article as the conflicting one, wouldn't be enough just to drop that article from the publication, instead of deleting the...

Please post the exact code you are using and I will take a look at it - thanks

Videos would be great, however, examples which are more practical would be even better. All too often I've found that the examples in most books hardly ever relate to...

If you set up transactional replication using the GUI, it does quirky things behind the scenes (like automatically set settings you really don't want). To ensure you don't take...

I knew I should have completely finished my first cup of coffee for the morning before posting this 😀

Issue resolved (walking away with tail between my legs in shame...)