thanks a lot Adi,

your tips were very helpful..

sorry for not to be clear for point 3), i restate: i m not aware of reasons but i have read that...

i have been reading about identity columns and have almost decided not to use them!

Problems: 1) @@identity gets lost in transporting tables 2) missing identities in case of rollbacks...