 <p>You have to check everything is the same...</p> <ul> <li>Correct DB?</li> <li>Correct schema? (eg foo.MyTable and dbo.MyTable)</li> <li>Correct column order?</li> <li>Trigger?</li> <li>Concatenation or some processing?</li> <li>Same data being inserted?</li> </ul> <p>Edit: What was it of my list, out of interest please?</p>