'Does the delete operation block any insert into the same table?

I have table A and a stored procedure that deletes all data from that table periodically. All queries in the stored procedure are packed into 1 transaction. But sometimes the stored procedure execution takes up to 5 minutes. Could it be that executing stored procedure will block inserts on the same table A?

The stored procedure will never be called again until the previous call has been completed.

Will it be different for READ COMMITTED and READ COMMITTED SNAPSHOT ISOLATION?

sql-servertsqlsql-server-2019transaction-isolation


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions