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: Yesterday @ 4:03 AM
Points: 411, Visits: 125
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 5:32 AM
Points: 624, Visits: 1,129
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: Yesterday @ 4:03 AM
Points: 411, Visits: 125
Indeed ..an insert operation was on.
Thanks
Post #1586291
Posted Thursday, June 26, 2014 3:35 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 5:32 AM
Points: 624, Visits: 1,129
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