I have a project that I am working on, where I call SQL Server stored procedures from with C# code. My problem is that the stored procedures will work fine for some random period of time, then all of a suddent they will stop working when invoked from within the C# application.
If, I go to my Database project or to the SQL Server 2008 R2 Management Studio, I can execute them without any problem.
The only way to get them working again that I have found is to drop them and the create them again. However, that is not acceptable for an application that will be running in a production environment.
Has anyone else encountered this problem. If so, how did you get around the issue.