Mulit-user database question

[riteshjain1982]

If 2 users are working on the same database and table and if one of them makes a change will the changes be reflected immediately to the other user?

Changes done by one user will not be reflected back to other user unless it gets loaded again from the database........may be you can use one datetime column in you table which will store the last modified datetime (GetDate()) and always compare this column's value of edited record with the value store in table....and if both value are not same you can inform user that this record is already been updated and he need to reload the record before updating the same.