Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

In your code where you run the stored procedure you should have something like this:

SqlCommand cmd = new SqlCommand(...)

Add such a line of code:

cmd.CommandTimeout = 0;

This will wait as much time as needed for the operation to complete.