I am getting the error "The timeout period elapsed prior
to completion of the operation or the server is not
responding" after some 18 hours of processing on SQL
Server.
I have executed a stored procedure from C# and it takes
some 30 hours for execution but this error came in between
after 18 hours and process stopped.
I have set the command timeout property to 0 (infinite)
but then also this error came.
Any pointers to reason for this error and solution will be
welcome.
TIA
Vivek