Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 query return results delayed

Author  Topic 

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2001-11-15 : 13:32:01
I have a rather long SP that I debug regularly with varius select statement within the SP. Usually the SP returns the values in QA as the statments are executed. Now the values are not returned until the entire SP is complete.

Does anyone know what would cause this?

My DBA is trying to tell me that because a restore is being done that data getting to the server is being delayed. This cannot be true because I can run other smaller SPs after I kick off the big one and they finish first, they also exhibit the same behavior.

Cat

   

- Advertisement -