Chuck,

thanks for your advice but I try to avoid using stored procedures, because I want to stay db independent. I found a very interesting article by Phil Brammer:

http://www.ssistalk.com/2007/02/20/generating-surrogate-keys/%5B/url%5D

This is how...