Timeout on query with blob data RRS feed

  • Question

  • We've recently started having a problem querying tables with blob data from SQL Server Management Studio. If I try and select even just one row, after a few minutes I get this error:


    SQL Execution Error.


    Executed SQL Statement: ...

    Error Source: System.Data

    Erroy Message: Invalid attempt to Read when reader is closed.


    It seems to be some sort of timeout error, if I query the row and select the other columns that don't contain blob data, the result is returned fine. If I remote the machine that the database is on and do the query, the result is returned just fine. Likewise, when I exported the tables to a database running from my workstation, I can pull the data, but it seems that querying the databases remotely is causing a problem. Any ideas? We've only been having this problem for a week or so, but it's happening on all of our servers.



    Friday, August 3, 2007 5:29 PM