I simplified the code to just the gist of it and the unique field is an identity column so the value should be generated from the database. The unique column...

jpipes,

I appologize for my remarks yerteday. I overreacted a bit and I know you were just trying to help and I mistunderstood some of the comments. On second thought they...

This if for jpipes, STOP replying to this thead as obviously you are a MORON!!! Your comments so far have been inane and not to the topic at hand. Maybe...

Hi All,

Thanks for the replies.

The reason I cannot use an identity column is the customer says no to it as they need have no gaps between registration ids.

The problem with...

Hi All,

thanks for the assistance. Any idea why the insert would be failing when the primary key is the identity field? And why would a stored procedure in a transaction...