We're getting a very weird error:
The stored procedure '***********' doesn't exist.
The solution to this may seem obvious but it's not. The website runs fine but with use and some traffic it starts popping up with this error on all pages accessing the database. While it's doing this, the stored proc(s) are there and they run fine via managment
studio. Restart the website in IIS and it's fine again.
I have run a trace while this is happening and funny enough the specific proc doesn't show up in the trace at all.
This is happening on our dev and qa environments. Both running SQL2008 and IIS7.
Anyone else experienced this and have a solution for me please?
View Complete Post