database unconfirmed deadlock t-sql 2005
===

For instance, there exists table A and table B, and i need to process an update in A and then B and I decide to lock both them during use (as demanded by my architect). Simultaneously, another procedure is called which locks B, then locks A.

Will this transaction complete? I have a feeling its a deadlock, quite sure of it as it's not releasing any resources...