Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • 1
    Why don't you use sqlcmd to run the sp and store the output in a file? That is easier to handle afterwards and prevents management studio from running out of scarce resources. Commented Oct 22, 2012 at 7:03
  • Actually I have many queries, only some of them are SP and others are larger query batches with variables, and in Studio if I choose file mode then it saves in file as well as shows in the panel. FYI In my org we have to go through very long documentation and approval process to update (to covert all to SPs). I wanted to know if there is a shorter solution for now. Commented Oct 22, 2012 at 10:19
  • 1
    why on earth are you processing 3 million records one at a time? Commented Oct 22, 2012 at 19:52
  • I already thought of bulk processing but as I have to re-calculate ledger etc of 3+ million clients and since I have to use some formula for each transaction, I have to do what I am doing. And I don't have much time to do so, that means it should complete without any stopping. Commented Oct 25, 2012 at 7:39