Results 1 to 5 of 5

Thread: [RESOLVED] identity seed incremented in transaction

Threaded View

  1. Sep 16th, 2008, 01:23 PM #1
    angelica
    angelica is offline

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2004
    Location
    in the heart of the Mediterranean
    Posts
    1,143

    Resolved [RESOLVED] identity seed incremented in transaction

    HI,

    I have the attached

    On inspecting my T_SQL I think I need to insert Rollback in the INSERT part of the SPROC. For example when USERID (field) was missing in tb_Translog, the identity for that table was still executed because the next correction entry had skipped a record.

    I wonder if someone can give some advice pls.

    PS I have included a ROLLBACK for every error message but I am still getting the indentity seed incremented. I am updating the file. Anyone can give me some expert help on these transactios pls
    Last edited by angelica; Sep 16th, 2008 at 04:25 PM.
    ------------------------------------------------------------------------
    If an answer to your question has been helpful, then please, Rate it!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width