the reason i put the set xact_abort on is because the stored proc uses distributed transactions. Initially we couldn't get SQL Server to allow us to use distributed transactions. So,...

I've tried that..... it worked the first time but didn't work after that. Not too sure why.

But anyway, i've finally found what was the problem. It is a stored...

hmm.. that is an option. Thanks for the suggestion.

Sorry about that, just hit the wrong button.

Thanks Andy for your quick reply. But the solution does not solve my problem as there may be other errors like field...

quote:

---

If you are using a unique index (not a unique constraint) you can check the 'ignore duplicate key' check box on the...