If a Stored Proc (SP1) calls another Stored Proc (SP2) and the called Stored Proc (SP2) hangs on a page or table lock, will SQL Server then Kill the whole process (SP1 and SP2) or will it only Kill the called Stored Proc (SP2) and return to the calling procedure (SP1)