Jacob Wilkins (5/24/2016)

---

Pretty sure it requires sysadmin.

There's an active Connect item complaining about this: https://connect.microsoft.com/SQLServer/feedback/details/351698/msit-mso-debugging-sql-query-fails-with-an-error-the-execute-permission-was-denied-on-the-object-sp-enable-sql-debug.

The Microsoft engineer who responded initially said:

The minimum security requirement is sysadmin. This is by...

"Tables should have primary keys." I wish others believed/thought that way, because I see a lot of tables with no keys of any kind, let alone have a primary key.

quackhandle1975 (5/23/2016)

---

Full marks Rob, at least you understood the implications and made changes to resolve that. My issue is the in house devs who are developing with full sysadmin...

I've been added to the db_owner role in that database. It's our understanding that would be more than sufficient in order to make it possible for me to debug stored...

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...