Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server not response SELECT

Posted on 2004-10-19
3
Medium Priority
?
203 Views
Last Modified: 2012-06-21
Hello Experts, I want to verify data in a table that has a few rows, but when I try it with a simple select sentence, SQL Server  not response me. Is the table locked ? What sentence will I use for know what tables are locked???
0
Comment
Question by:karencita78
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 70

Accepted Solution

by:
Scott Pletcher earned 200 total points
ID: 12352575
Cancel that SELECT and from QA try this:


SELECT ...
FROM tableName WITH (NOLOCK)
WHERE ...
...


If that works, then the table was locked.  You can use this to find locks:


EXEC sp_lock2  --if it works
EXEC sp_lock  --if sp_lock2 doesn't work

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question