You have a stored procedure that is used to set up maintenance tasks. The stored procedure executes every night.
The stored procedure contains three critical data manipulation language (DML) statements that operate against a single table.
You need to prevent users from modifying any data in the table while the stored procedure executes.
Which locking hint should you use?
A. NOLOCK
B. READCOMMITTED
C. REPEATABLEREAD
D. TABLOCKX
