hello,

when i run the script to build the procedure proc_Insert_To_Log

i get the following message

Msg 208, Level 16, State 0, Procedure proc_Insert_To_Log, Line 22

Invalid object name '#Tmp_Inserted'.

i run it on sql server 2005

thanks for the code so far!!!

greetings and nice holidays and a good new year!!!