>>Hi,
>>
>>I have a delete stored procedure that deletes records from multiple tables. There could be up to a few thousand records in a couple of those tables and a few hundred in a couple others.
>>
>>Unfortunately this is timing out. See the exception information below. Is there a way for me to increase the timeout period for this operation?
>>
>>System.Data.SqlClient.SqlException was unhandled by user code
>> HResult=-2146232060
>> Message=Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
>> Source=.Net SqlClient Data Provider
>> ErrorCode=-2146232060
>If you can get to the DBDataAdapter then you could try 'dataAdaptor.CommandTimeout = x;'
>
>But since this is wrapped in MM I don't know whether that would be possible......
Thanks Viv, I'll see if I can.
Interesting that it failed the first couple times but then ran fine afterwards. I guess this gave SQL Server time to optimise the stored procedure.