Today I have been trying unsuccessfully to save a comment for the Update report for the date 04-SEP-2012 for Oven 5's cook program but I am getting today that Timeout Expired error and that Update report's stored proc is blocking the update stored procedure in the Update report's ReportViewer code behind. Today I was connected, as I am usually, to the database on the Windows Server 2003 machine that is an older machine.

So just now I restored the database to a different machine that has Windows Server 2008 and that is much beefier than the ol' Windows Server 2003 machine.

I connected the web app's code where applicable to this new Windows Server 2008 machine.

I ran the application from within VS 2010 connected to this new Windows Server 2008 machine. I tried to add comments to the Update report for the 04-SEP-2012 for Oven 5's cook program and it worked! This is the same cook program for which I'd been trying to update the comments in its Update report all day when connected to the old Win Server 2003 machine with no success today.

But then, still connected to the Windows Server 2008 machine, I tried to update the comments for the Update report for the 04-SEP-2012 cook program for a different Oven 2 and again I get the Timeout Expired error in the web app and again that Waiting Query showed that the Update report's stored procedure that selects data is blocking the update stored procedure.

So this problem occurs sometimes on a Windows Server 2008 machine just like it happens sometimes on a different Windows Server 2003 machine.

Hviezdoslav Monday 10-SEP-2012