<div>
Thanks for your comment..Pls find my replies to your comments.<br />
1. I have a clustered key on the table.<br />
2.Using WITH NOLOCK option does help in preventing this problem.
</div>


Thanks for your comment..Pls find my replies to your comments.
1. I have a clustered key on the table.
2.Using WITH NOLOCK option does help in preventing this problem.

<div>
<div class="content wysiwyg-content">
I have put a query in SQL Query Analyzer Select top 17777* from &lt;Table name&gt; It takes lot of time to get the output.I stopped it using stop button in Query analyser. Now that process ID is blocking any other query to be executed on the same table. This does not happen everytime. But I would like to know if someone is facing the same problem.
</div>
</div>


I have put a query in SQL Query Analyzer Select top 17777* from <Table name> It takes lot of time to get the output.I stopped it using stop button in Query analyser. Now that process ID is blocking any other query to be executed on the same table. This does not happen everytime. But I would like to know if someone is facing the same problem.

Locking in SQL Server

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.