Forcing a table lock in SQL Server 2000
Posted on 2010-08-12
We are testing a program change that locks a table when it updates. There can be multiple requests for this update and we have error handling that does this. We want to test this functionality before we move it to Production, but I'm having a hard time finding a way to force a table lock so that we can test the error processing. I have seen a way through bcp, but I'd prefer not to do it that way. In the query, we are locking using a Transaction and the TABLOCK and HOLDLOCK hints. This is in SQL Server 2000 accessed through vb.net.