Deadlock by getting SCOPE_IDENTITY()

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  December 5, 2013 at 9:30 pm

  #285747

  Hi,

  I need a unique value for a composite key. I have created a little table that has an IDENTITY column. I inserts a record via StoredProc., And get as output parameters the SCOPE_IDENTITY ().

  In a BulkInsert from a flat file, sometimes it comes at a high load to a DEADLOCK on this place....the procedure continues to run without having the key :w00t:

  Is there a better method to get a UniqueKey quickly?

  BestReagards

  Nicole

  😎

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  December 9, 2013 at 5:09 pm

  #1672176

  Can you try by replacing SCOPE_IDENTITY() with @@IDENTITY?

  SCOPE_IDENTITY() returns the current identity withing the current scope, while @@IDENTITY is not scope limited.

  Regards,

  IgorMi

  Igor Micev,
  My blog: www.igormicev.com