I found my cause and learnt somthing new. The internal object ids may not be sequential, but they are not random. I had built my database tables using a script...

I had the same thought but I couldn't find any additional triggers. I was wondering if an "instead" trigger may be firing. I may have finally found something which may...

Further testing has revealed additional information. If I insert data into the view, the data is going into the correct database but is firing the trigger from the other database.

INSERT...