<div>
In your vb app, start a transaction <br />
Then select * from your table<br />
Then sleep // do your tests<br />
Then rollback
</div>


In your vb app, start a transaction
Then select * from your table
Then sleep // do your tests
Then rollback

<div>
&quot;In your vb app, start a transaction <br />
Then select * from your table<br />
Then sleep // do your tests<br />
Then rollback&quot;<br />
<br />
This did not work. &nbsp;I started a transaction in vb.net did the select * and a sleep for a minute. &nbsp;While it was sleeping, I ran the other program which reads then updates the record and it successfully read and updated.<br />
<br />
Any other ideas?
</div>


"In your vb app, start a transaction
Then select * from your table
Then sleep // do your tests
Then rollback"

This did not work.  I started a transaction in vb.net did the select * and a sleep for a minute.  While it was sleeping, I ran the other program which reads then updates the record and it successfully read and updated.

Any other ideas?

<div>
This worked thanks. &nbsp;If anyone else has this issue, make sure you turn off the option in Query Analyzer that disconnects after query executes before you run the SQL.
</div>


This worked thanks.  If anyone else has this issue, make sure you turn off the option in Query Analyzer that disconnects after query executes before you run the SQL.

<div>
<div class="content wysiwyg-content">
We are testing a program change that locks a table when it updates. &nbsp;There can be multiple requests for this update and we have error handling that does this. &nbsp;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. &nbsp;I have seen a way through bcp, but I'd prefer not to do it that way. &nbsp;In the query, we are locking using a Transaction and the TABLOCK and HOLDLOCK hints. &nbsp;This is in SQL Server 2000 accessed through vb.net.<br />
<br />
Thanks
</div>
</div>


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.

Thanks

Forcing a table lock in SQL Server 2000

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.