Hi,

Thanks for the reactions, try catch in the trigger does raise the level of stability but still doesn't seperate the two processes.

The number of insertions is not extremly high. Maybe...

Hi,

Do not know if it is possible to run as a script, depends on the stored proc. you've developed.

One tip I've still got for you, when running into #tables...

Not that definitly at the client 😉

If you are sure that you code will reach the commit or rollback statement at the client is a choice BUT.... if you are...

Hi,

First execute everything from query analyser or development studio that rules out any effects of the ado or ado.net layer you that's what you are using.

Second if you are using...

Hi,

Use identity, replication is much more mature than your own procedures of creating an unique number probably will ever be (no disrespect intended).

If you are not looking for a identity...