views:

344

answers:

1

I have a couple stored procedures that run for about 2-3 minutes a piece (lots of data). When I run the stored procedures inside SQL Server Management Studio, the queries run fine and return the appropriate data, however, when I run my SSRS Report, it errors out with "Object has been disconnected or does not exist at the server."

Any suggestions? I think it has to do with the time it takes to run all the queries.

I have tried setting WITH RECOMPILE with no luck.