800a0e78 – Operation is not allowed when the object is closed
More geek stuff.
If you built a stored procedure, and it works beautifully in the Query Analyzer (or in SQL Management Console), but you get an “800a0e78 – Operation is not allowed when the object is closed” error when you run it from code, one possibility is that you left some debugging “PRINT” statements in the stored procedure. The Query Analyzer can handle it (and will usually sort those out onto a “Messages” tab separate from the “Results” tab), but programmatically calling the stored procedure will cause problems.
I just chased one of these down, and it took the better part of an hour to finally have the “A-HA!” moment where I realized that the debug code was still in there.
Hope this helps you solve it quicker.