After SP1 the problem with Violation of Primary Key Constraint Error returned when we tried to run the incremental job. The previous Hot fix (936867) from Microsoft for this seems to have been overwritten by the SP.
We got this error:
Content deployment job 'Incremental Content Deployment' failed.The exception thrown was 'System.Data.SqlClient.SqlException' : 'Violation of PRIMARY KEY constraint 'PK__#ExportObjects____4F86F15A'. Cannot insert duplicate key in object 'dbo.#ExportObjects'. The statement has been terminated.'
To solve this we turned off minor versions on both the Style Library and the Site Collection Images library.
But it still did now work so I removed all previous versions of the files that had a version above 1.0 and that did the trick. (I created a flat view that only displayed the items with version greater than 1.0).
Thanks to the Hungarian SharePoint Geek that pointed me in the correct direction:
http://www.sharepointblogs.com/pholpar/archive/2007/05/22/primary-key-violation-when-using-the-spexport-object.aspx
Updated: The problem came back so I created a feature with a reciever that turned off the Parallell Worklow, Approval, Versioning and in and out checking of the libraries Images and Documents. Then a made sure that this feature was turned on in all my site templates and then I used a small console application to turn it on on all sites that were created earlier. That made the trick ...