Jamie,

So far it hasn't blown up. I need the sql administrator to configure the email system. It looked pretty straight forward and it will save time in having the application...

Thanks Jamie,

I've incoorporated that in my code and will assume it works. I didn't know that a procedue could return value. My next thing to figure out is how to...

Thanks for the advice. What happens when nested in these inserts is a call to a procedure. If an error occurs there. What will happen is an insert fails within...

Do I have to put if @@error != 0

begin

rollback TRAN T1

end

after each insert ?

Do I have to put if @@error != 0

begin

rollback TRAN T1

end

after each insert ?