I have a stored procedure. When I execute it in Sql Server Management studio it takes less then 1 second to return data.
It returns 21 rows and 13 columns.
When I call this procedure from .Net I get TimeOut, even though I extended the CommandTimout to 60 seconds.
I have a parameter in the stored procedure and when set to true it returns the first 7 columns instead of 13.
The strange thing is that when I only get the first 7 columns I do not get timeout and it takes very short time to load RadGrid with the data. I have no idea why this can happens. I hope someone can help me with this.
Attached is an excel document with the result from the query.