As a developer who was part of a team in the past that liberally hard-coded the 'sa' account and its password in lots of applications and all reports, I've got...

johnwalker10 (5/20/2016)

---

to fix this error create a new database role

CREATE ROLE db_executor;

then...

Thom A (5/20/2016)

---

You haven't accidentally changed your configuration at all have you? Each configuration will have a different TargetServerURL, so if you changed from Release to Debug, for example, you...

drew.allen (5/19/2016)

---

Rod at work (5/19/2016)

---

Just thought of something else to add to this. Years ago I was working with some other report generating product (I can't remember what it was...

Just thought of something else to add to this. Years ago I was working with some other report generating product (I can't remember what it was now), but I believe...

Yes Lynn, it does make sense. Thanks!

Lynn Pettis (5/19/2016)

---

Here is a simple way to swap two values to ensure StartDate is less than EndDate:

d e c l a r e -- spaced to allow posted from...

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.