Great feedback, everyone! Thanks!

Marcia J (5/18/2016)

---

Steve Jones - SSC Editor (5/16/2016)

---

Rod,

I think many companies tolerate pain in deploying software. I have no idea why myself, but I'm more baffled as to why Developers...

I don't know, Steve. I agree with you in principle. But I notice, at least in my current position, that there is a very high tolerance for pain in how...

OK, I found the problem. I didn't realize it, but the report already had a sort order in it. So naturally even if there's one in the stored proc, it's...

Joie Andrew (5/6/2016)

---

Are the results from the stored...

Spiff (5/6/2016)

---

The project configuration mode mainly determines the deployment options for your project so shouldn't really affect this.

I'm slightly unclear about the issue now - is it the data itself...

J Livingston SQL (5/8/2016)

---

Rod did you run the test script I posted?

1 Million row table

-- update 6 columns on 100 000 rows

--run 10 iterations of update with trigger on

--then disable...

Oh OK, thank you, Jeff.

Spiff (5/6/2016)

---

SSRS caches report data as a .DATA file in the solution folder.

Either run the report again and click the little "Refresh" icon - this should force SSRS to rerun...

pietlinden (5/5/2016)

---

What happens when you run the stored procedure inside SMS, not SSRS? Is there a chance that you're connecting to a different server that has a different copy...

Jeff Moden (5/5/2016)

---

Wayne West (5/5/2016)

---

Good points. My biggest table has 66 columns (all the other active tables have a very small column count), but even when I was inserting...

:unsure:

Its been over a week, I believe, since I created this thread. I want to thank you all for your feedback. I still don't have the requirements, as some of...

jeff.mason (5/2/2016)

---

Oh, you don't want to do that, especially in a system with MARS involved. That would cause multiple recordsets potentially. You probably want to make a log table...

Eirikur Eiriksson (5/2/2016)

---

Rod at work (5/2/2016)

---

The subject line says it all. I'm testing something in an UPDATE trigger. Basically, I'd like to do a printf() type of thing. I created...