Bonediggler1
Technical User
Hi -
I am developing a report that is based on a stored procedure in SQL Server. I made some changes to the stored proc this morning and it runs fine in Management Studio, and takes about 1 minute.
However, running the report now takes forever - actually i don't know how long because I always cancel it before it finishes. For testing purposes I created a new report based on the same stored proc that just pulls one field and it still takes forever.
Any idea why this is happening?
Thank you!!
I am developing a report that is based on a stored procedure in SQL Server. I made some changes to the stored proc this morning and it runs fine in Management Studio, and takes about 1 minute.
However, running the report now takes forever - actually i don't know how long because I always cancel it before it finishes. For testing purposes I created a new report based on the same stored proc that just pulls one field and it still takes forever.
Any idea why this is happening?
Thank you!!