Begin Transaction is locking the whole table

jokolee

New member
Joined
Jan 6, 2005
Messages
1
Programming Experience
10+
i using begin transaction in my query, and before the transaction is finish, why is the sql server is locking the whole table....? ( i'using Sql server 2000)....Did sql server can't just locking the row..? thans
 
Top Bottom