Table Locking

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Thomas Jacob (anonymous_at_discussions.microsoft.com)
Date: 02/14/04 

Date: Sat, 14 Feb 2004 05:31:05 -0800

Hi,

Do we need to lock the table while executing stored procedures ? How can we do it ?
Will 'Begin Tran' lock the tables automatically ? Then what happens when one procedure calls another and both has
transactions individually ?