Concurrency Issue

• MuhammadShafiq

  SSCrazy

  Points: 2509

  More actions

  February 23, 2012 at 12:02 am

  #256218

  From a long time i have an interesting question in my mind.Would you people like to clear me here in this case.

  Lets say we have one database. Two applications are using the same database.mean App1 and App2.

  Lets say here is a table named Table1.At the same time from different locations both applications(consider applications as operators) wants to edit/Update record num 5.How we will have a check that to control ans synchronize both application.

  For example record 5 have amount 10.if this is not syncronized one operator will see 10 and other wll see 15(when one update to 15).

  Hope you got it?

• Ant-Green

  SSC Guru

  Points: 113536

  More actions

  February 23, 2012 at 2:13 am

  #1450699

  duplicate post, all replys here please http://www.sqlservercentral.com/Forums/Topic1256431-338-1.aspx