select query does not return any resultset

• sharon-644450

  Default port

  Points: 1442

  More actions

  July 7, 2013 at 12:20 am

  #395095

  hi all,

  i have a table with 74 rows. when i run a select statement on it, it does not return any resultset.

  for the same query if i use the nolock hint , it does return the result.

  i ran a profiler to see what is happening behind the scene and i see only the SQL:BatchStarting

  i donot see the table being locked in the activity monitor. no error in the event viewer for SQL. only a below warning

  [ warning] [vmusr:vmusr] Error in the RPC receive loop: RpcIn: Unable to send . there exist a hotfix for this error and it will be applied.but not sure if the strange behaviour is due to this any suggestions ?

  also, if i run select statment against any other table it runs without any error.

  dbcc checktable returns no error.

  DBCC results for 'POLICY_LOCKS'.

  There are 74 rows in 1 pages for object "POLICY_LOCKS".

  DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  sql version: SQL server 2005 with SP4

  Windows: Server 2003 Enterprise Editionwith SP2

  thanks.

• MMartin1

  One Orange Chip

  Points: 27768

  More actions

  July 23, 2013 at 1:10 pm

  #1635106

  Try

  dbcc opentran

  to look for any open transaction. If nothing, you can try issuing a 'checkpoint' command on the database to commit data in the systems memory.

  ----------------------------------------------------

• WolfgangE

  SSCertifiable

  Points: 6328

  More actions

  July 30, 2013 at 7:15 pm

  #1637190

  Maybe you get some useful information about what locks the table using sys.dm_tran_locks (http://msdn.microsoft.com/en-us/library/ms190345%28v=sql.90%29.aspx)

  There are some other Transaction Related Dynamic Management Views and Functions that might help you: http://msdn.microsoft.com/en-us/library/ms178621%28v=sql.90%29.aspx