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