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

Table not returning any result Expand / Collapse
Author
Message
Posted Thursday, June 26, 2014 12:22 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 8, 2014 12:42 AM
Points: 416, Visits: 135
I am trying to run queries on a table (table has zero rows). Inspite of giving 0 rows returned the query keeps on running and I have to cancel it.I tried inserting a dummy row into the table but even the insert operation is taking too long.Every query which I hit on the table just keeps on running without giving any result.
But this is not the case with other tables in the database.They are all running fine giving proper results.But this one table is behaving funny.
Can anyone suggest what might be the error?\

Thanks in advance.
Post #1586231
Posted Thursday, June 26, 2014 1:18 AM This worked for the OP Answer marked as solution
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 8:01 AM
Points: 688, Visits: 1,234
did you check any transaction on this table ?

Post #1586255
Posted Thursday, June 26, 2014 2:35 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 8, 2014 12:42 AM
Points: 416, Visits: 135
Indeed ..an insert operation was on.
Thanks
Post #1586291
Posted Thursday, June 26, 2014 3:35 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 8:01 AM
Points: 688, Visits: 1,234
Okay, Glad to help. Old DEV mistake. Should be in the checklist from now on .
Post #1586321
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse