TimeOut expired error when selecting more than 300 rows

[Charl]

Hi
I have a small VB.Net app that needs to process data from a SQL 2005 DB. All works well when I limit the number of rows returned by the stored procedure to less than 300 (select top 300...) . As soon as I select all the records I get a timeout expired. When I run the SP in query analyzer it returns all the records (about 1100) in less than a second. The connection is established, I get the error on the execute command.

Please Help!!

Charl

[ck9663]

Lots of factors. Among them:

1. The object you're using to connect to your SQL Server.
2. The sys-ad can actually configure your server to timeout in different manners and prioritize queries.

-- CK