run sp_who also....

ideally there should be many records......

try running with nolock clause also

still same then post ur queries and sql servre versions details or anything which u think can help debugging