A bulk update lock is a special type of lock used only when bulk copying data into a table using the
bcp utility or the
BULK INSERT command. This special lock is used for these operations only when either the
TABLOCK hint is specified to
bcp or the
BULK INSERT command or when the
table lock on bulk load table option has been set for the table. Bulk update locks allow multiple bulk copy processes to bulk copy data into the same table in parallel, while preventing other processes that are not bulk copying data from accessing the table. If there are any indexes on the table, or any other processes already holding locks on the table, a bulk update lock cannot be granted.