Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

select query does not return any resultset Expand / Collapse
Author
Message
Posted Sunday, July 7, 2013 12:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 7, 2014 5:26 AM
Points: 110, Visits: 714
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.
Post #1470965
Posted Tuesday, July 23, 2013 1:10 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 5:30 PM
Points: 352, Visits: 867
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.
Post #1476762
Posted Tuesday, July 30, 2013 7:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 6:41 AM
Points: 197, Visits: 729
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
Post #1479251
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse