Query Analyzer....

[Vaderman]

The Query is as follows :

Insert into TableName
select T.ID, T.RecordType, T.Status, T.Available
from (TableName T inner join Selection S on S.selectionID = T.ID)
                              inner join Assessement A on S.EventID= A.ID
where A.highlighted = @InputParameter

The above query works as expected as it returns the number of rows as expected for a given @InputParameter

However, the following SQL is where the problem lies:

select count(*) Select_Count from TableName
where RecordType = 'T' and Status='C' and Available = 0

All the above SQL is wrapped up into a stored procedure and is called within my application.
But the last SQL select statement above times out after 30 seconds in my app, but in the Query analyzer it continues to be executed for as long as 10 minutes. There is no reason as to why it keeps on executing or timing out as the rows returned maybe 0 or 1000 (max) at any given time.

In the Profiler, *sometimes* it will state that the last SQL has completed, but in the Query Analyzer it will be shown that its still executing.

I think it may prove tto be helpful that these two SQL procedures are run when there is alot of traffick on the database server network.
Any explanations?