Unanswered: Stored Procedure too Complex? WrapperRead Error
I have a SP that when I run I get a
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead())
It really seems like its in some sort of correspondence with how much the procedure does. As if I put some watches in it, I get further into it the less I have going on.
Really all the procedure does is clear a table and add to it and update it until the information is correct enough for a report to be run from it.
If I run the procedure through query analyzer on my client machine it will bomb and return the error in like 4 minutes.
If I try to run it on the server, it will run it foir like 11 minutes before it bombs.
Any thooughts would be great.