I have a number of stored procedures I call from code with ExecuteNonQuery
.
It was all good but 2 of my stored procedures started timing out intermittently today with:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.
If I execute the sp manually from management studio it's still all good.
Nothing recently changed in my db - my command timeout is the default one.
Any clue?
EDIT
the table against the SPs are running it's huge --> 15 Gigs. Rebooted the box - same issue but this time can't get the sp to run from Management Studio either.
Thanks!