Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pap
Starting Member
13 Posts |
 Posted - 2004-03-03 : 08:36:02
|
| Hello,For sure that this is a dummy question but can you explain me how SQL Server reacts to the fact that we have the same application running in two different pc's and this two applications intent to insert,update, delete or even read a record from the same tableDoes "he" blocks the record until one of them leave the table ??? And if the other tries to update at the same time ???Thanks,Paulo |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-03-03 : 08:39:17
|
| It will probably lock the row and the other will wait until it is released if the action is on the same row.For updates it maens that the update from one app may be reset by the updatre from the other.For a read - two reads will take shared locks and so be ok but will wait for an update to comple.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Dummy question