January 15, 2007 at 1:39 pm
I am debugging some code that was written using a cursor loop. Currently, it is looping through 1+ million records and doing multiple selects and updates on each pass. (I know, not exactly an efficent way of coding this, but it's not my code.)
Without stopping the current process, is there a way to view where it is within these million records?? It's been running for 14 hours now, and I'd hate to stop it if it is almost done.
Thanks,
K-
January 15, 2007 at 1:49 pm
What process is it doing exactly? Maybe you can check for traces in other tables (like a flag set to X value).
Because I doubt that you can have access to that information from outside the procedure... but I've been known to be wrong from time to time.
January 15, 2007 at 1:57 pm
It's updating the table the data originally came from, and unfortunately it's not such that I could query and find which ones were changed.
January 15, 2007 at 2:02 pm
Any auditing done on that table, either in another table or a lastupdateDate column?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply