I am working on T-SQL stored procedure. This sp inserts millions of records into a table. I would like to add some error handling logic into this stored procedure, to make sure if there is any issue with data in process, I would like to restart the stored procedure from the last commit. How do I accomplish this?. I would appreciate your help on this. Raga.