Last week I had a blog about getting better error messages out of SQL Agent Jobs. In that blog I had encountered the following error message:
Error: 2010-06-23 19:00:30.68
Source: Execute SQL Task
Description: TCP Provider: The semaphore timeout period has expired.
The downside is that I don’t have a good explanation for why this error occurred. I talked to those that would investigate it and handed it off.
The point for today is that after a lot of searching when this error came up, it turns out that there is a Microsoft KB article that is worth taking a look at when you encounter this error:
If you encounter this error, I wish you luck. And hopefully you found the link I referenced faster than had I not put this out there.