It's possible that you may be missing an index on that table so an action is taking a table lock instead of lower level lock.

Prayers for you and your family Roy.

Manie,

That's a good one, I think I've heard a similar story before.

Steve,

I don't usually turn on the lights, but I do let natural light in. Of course the emergency...

Lempster,

I'd have to look into using the Log providers. I actually learned some about them AFTER I wrote the script component and article. As you can see from...

I don't think that there is a way to do what you want at least not dynamically. Could you use a textbox above each subreport with static text and...

Have you tried using the AVG() aggregate function in the second matrix? Or is there some reason why this doesn't meet the need?

Are you rendering all the sub-reports at the same time in the main report or is there something in the parameters or data that determines which sub-report is rendered?

John,

Thanks for the nice comment. Just so you know earlier in the thread I attached an SSRS report that displays the data from the catch-all data, parsing the xml...

Thanks for the positive feedback dg.

Nico,

This article deals with 2005. In the post just before yours there is a link to an article for 2008. Here it is...

Duh, my bad Matt. I had a brain cramp. A primary key cannot contain a nullable column. I was thinking unique constraints which would be a natural...

Bob Hovious (4/2/2009)

---

Just a thought here... but it suddenly dawned on me that any time he posts, it might not hurt to post the set of links Gail compiled as...

Ouch! How does anything work that is accessing that table?

Well, it depends on how you are calling it. If you are doing something like this:

Exec [dbo].[UserRoleMapping] parameter list

Then you will not get anything returned as this type of...

Duplicate post. Please post any answers here

Have you verified that the linked server user has Select permissions on the table(s) where the queries are failing?