Concurrency Violation

• krypto69

  SSChampion

  Points: 13604

  More actions

  August 27, 2015 at 10:10 am

  #398953

  We have this view works fine:

  SELECT

  geoCodekey,

  addressID,

  address1,

  address2,

  city,

  state,

  zipcode,

  Geoinfo,

  Latitude,

  Longitude,

  NewCounty,

  Designation

  FROM dbo.member_address

  JOIN pec.tGeoCodingData

  ON member_address.member_address_id = tGeoCodingData.addressID

  IF we add 'TOP 2000' to the above we get :

  Concurrency violation

  What can we to?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 27, 2015 at 10:13 am

  #1822839

  What's the full error?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• krypto69

  SSChampion

  Points: 13604

  More actions

  August 27, 2015 at 10:43 am

  #1822855

  Concurrency Violation:

  The update command effected 0 of the expected 1 records

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 27, 2015 at 10:48 am

  #1822858

  Ok, you're going to have to explain far more what you're doing, because a select cannot cause an error updating. So, details???

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• krypto69

  SSChampion

  Points: 13604

  More actions

  August 27, 2015 at 10:57 am

  #1822862

  Sorry Gail I don't think you'd be able to help us further.

  The offending program is a third party application that we cannot control.

  We were hoping we could fix the error on the SQL side - but doesn't look that way.

  As always, thank you Gail for trying to help us.