Request to please check earlier post if you don' t mind..

The begin and commit transactions are present as data are finally updated to base tables using data from temp tables further in application.  Yes, the transactions are required for the...

Would be glad to know if there was a chance to check the script posted earlier please?? Request to know whether any hints on the timeout issue??

Thanks,
Aravindan...

Thanks for the reply. Please find attached the SQL code which gave the timeout exception. The logs for application stopped with the timeout error.when accessing / inserting into temp table...