SQL Server Performance

stored procedure - backup & recovery

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by Raga, Jul 5, 2006.

  1. Raga New Member

    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.

  2. Madhivanan Moderator

  3. Raga New Member

    thanks for your response Madhivanan.

    I read this article, but I still have some questions. How could I able to restart the sp from last commit point?.

    Please advise.

Share This Page