ADP and SQL server 2000 reports cancelled

B

Ben

I have an ADP that runs stored procedures from a SQL server 2000 database and
now that the table size has reached over 2million records, when we run the
reports, they just cancell them selves with no error being raised. I believe
this is caused by some sort of timeout occuring because SQL server is taking
too long to return records.

Is there any way to fix this? My users understand that they will need to
wait for their results due to the record size.

Thanks for any and all help
ben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top