[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.axapta.programming

Database locks

frango

1/27/2006 4:12:00 PM

Hi,

Could anyone briefly explain the differences between all kind of database
locks (i.e. Record lock, Index key lock, Page lock, Table lock).

Furthermore, does a 'while select forupdate xxx where yyy' exclusively locks
all the table or only the records matching the 'where' clause?

Does a 'database lock' have somethig to do with a 'deadlock'?

Thank you in advance,

Frango
1 Answer

Luegisdorf

1/30/2006 3:18:00 PM

0

Hi Frango

look here:
http://www.awprofessional.com/articles/article.asp?p=26890&seqNum=...

there are all lock types from MS-SQL 2000 listed and explained. And you're
going right: a 'database lock' can raise a 'deadlock'.

Best regards
Patrick


"frango" wrote:

> Hi,
>
> Could anyone briefly explain the differences between all kind of database
> locks (i.e. Record lock, Index key lock, Page lock, Table lock).
>
> Furthermore, does a 'while select forupdate xxx where yyy' exclusively locks
> all the table or only the records matching the 'where' clause?
>
> Does a 'database lock' have somethig to do with a 'deadlock'?
>
> Thank you in advance,
>
> Frango
>
>