aargh..thanks for that info Krzemo

i never used trigger in my DB, so never run into any trouble ..will change it to SCOPE_IDENTITY() ASAP