"Dean Slindee" <slindee@charter.net> wrote in message
news:CMvBh.178$vg7.100@newsfe05.lga...
> "The timeout period elapsed prior to completion of the operation or the
> server is not responding".
> ExceptionType: System.Data.SqlClient.SqlException
> Method: OnError
>
> I am getting the above error message when calling a long running stored
> procedure from a VS2005 WinForm application. Using Windows 2000 OS with
> SQL Server 2000, ADO.NET, Framework 2.0. The stored procedure just takes
> some time to build a lot of tables in SQL Server. To be a little more
> precise, the one stored procedure calls four more stored procedures (doubt
> it matters, but just in case...)
>
> So, my question is this: is there a setting in VS2005 or SQL Server that
> I can turn off or extend so that this timeout is disabled?
>
> Thanks in advance.
> Dean Slindee
>