Hi Experts iam using temp db in my sp after completing my work at the end of my sp am deleting that temp table.
Now i got a problem while running my sp for some 5 lakhs records at the end am getting the error log msg as
Error Occured in :Loln_spodcamtcalculationM
essage : The transaction log for database 'SHRICITYREPORT' is full due to 'LOG_BACKUP'. Rollback Succesfully
how can i avoid the error how to handle in my sp. am attaching my sp