Evil Kraig F (8/28/2014)

---

Lynn Pettis (8/28/2014)

---

I really must be getting jaded. I get chastised for not being able to figure out what some ones uncommented and convoluted code on...

Can you share your complete query?

It sounds like you are doing something like this:

SELECT

I.*,

SUM(final) OVER(PARTITION BY InvoiceNmbr) AS invoicedTotal

FROM

...

Yes

I don't think so.

tacy.highland (8/28/2014)

---

The permissions to the report are inherited from the folder it's in, which is inheriting from the root. So nothing special about the report specifically.

This is just weird.

I...

Sorry, I'm basically tapped out. The only other things I can think of are:

1. A network trace using...

Okay there are a couple of things I've found that relate to security and UAC that might be the issue, but I haven't seen the behavior you are seeing when...

What version of IE?

michaeleaton 36224 (8/27/2014)

---

Thanks everyone for your help. Jack's solution works just great. I probably should have posted the output I wanted, but in essence I wanted it grouped by Username...

You type in the Logical Name for the file and you get that by using RESTORE FILELISTONLY. Check out RESTORE in BOL.

acapone (8/27/2014)

---

Thanks Jack. Is it possible to restore backups to an older version of the database?

What I mean is the database backups will be taken from one server, and...

have you looked in the ExecutionLog3 view in the ReportServer database to see if the execution is ever finishing from the server perspective?

I think you can also query RunningJobs to...

I'd agree with most of what gbritton1 has said although I'm not a fan of putting user procedures in master (with a few exceptions like sp_WhoIsActive).

I don't know of any...

Definitely would be easier to answer with some sample data and expected outcome, but here's what I've come up with:

WITH newCustomers

...

What do you mean by put in another database? Do you mean move the stored procedures into the database(s) that they source their data from or move them into...

I'm not aware of any issues with this DMV. What makes you think the procedures weren't executed?