Jmathai,

I theory, row level locking is automatic... but the exact results are based on way too many things:

a) Lock type - Pessimistic / Optimistic

b) Number of indexes

c) Type of indexes

Under some...

I had a major problem with deadlocks many months ago.  I did follow the advice mentioned above.  I needed a lot more control over the locking.  The main things I...

Sholliday, that article was an excellent resource.  I did write the code in VB 6.0 but I operate in mostly disconnected mode.  I create connections on the fly, as needed,...

Antares, I really appreciate your input.   Thanks!

Thanks David... I do appreciate your comments.   Our application is designed to connect and disconnect in very sub-atomic routines.    I was wondering if the Begin/Commit Transaction mechanism works the same. ...