Concurrency Violation

Question

Concurrency Violation

krypto69

SSChampion

Points: 13591
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?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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: 13591 More actions · Answer 2

Concurrency Violation:

The update command effected 0 of the expected 1 records

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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: 13591 More actions · Answer 4

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.