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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Transaction and commit

Author  Topic 

kamal.A
Yak Posting Veteran

70 Posts

Posted - 2009-08-03 : 00:44:12
Hi all,

I have one scenario..

One admin user want to update the user informations.. at the same time another one admin user update the same user information. but first admin user select the user information and updating the informations, the second admin user select the same user information and change some information and save the record. What will be happen for this scenario?

If sql server handles or we should programmatically handle? kindly give me user advice.

Sachin.Nand

2937 Posts

Posted - 2009-08-03 : 02:59:37
Maybe you will want to have a look at this article

http://www.sqlteam.com/article/introduction-to-locking-in-sql-server


PBUH
Go to Top of Page
   

- Advertisement -