0

For several years I've been using a C# application that is using a SQL Server 2005 Express database with about 250 tables. What could cause suddenly (never happened before) a simple SELECT * query from a single table to read all records from the table, but not reaching "Query executed successfully"; instead the query hangs, and stops only after timeout is reached.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user3654312
  • 1
  • Are you sure it is returning ALL rows. I have seen in testing where a Transaction is Open and a row is inserted into a table. Another connection is opened and selects from the table. That select will return rows but no all of them until the other Transaction is committed or rolled back. – SteveB May 19 '14 at 21:58
  • Does select * from table WITH (NOLOCK) hang? – Eric Hauenstein May 19 '14 at 22:38

0 Answers0