>>I only see Remote Query timeout here which is set to default 600 seconds. I set it to 0, but I don't think this is it.
>>
>>Where exactly did you find these two settings?
>>
>>Thanks a lot in advance.
>>
>>UPDATE. I see them now in View Connection Properties, but how can I adjust them? They seem to be read-only.
>
>I put that value in the SQL select command such as in:
>
>
>oCommand.oCommandTimeout = 0
>
In other words, you adjusted in it .NET code, not from SQL Server itself.
Thanks.
If it's not broken, fix it until it is.
My Blog