Intent locks are placed on higher-level db objects when a user or process takes lock on the data pages or rows. An intent lock stay in place for the life of the lower level locks
Intent locks are placed on higher-level db objects when a user or process takes lock on the data pages or rows. An intent lock stay in place for the life of the lower level locks