Drew,

Thanks for replying and I know this is a few months old now (Just now getting time to go back and deal with this one) but unfortunately that will not...

One last interesting piece on this.

I just did some more work with this and I found something I consider to be rather odd. No matter how I setup the...

If I substitue TABLE A for a real table I get 100 (The...

Basically just a large set of easy to follow data to test...

Thank you kindly sir

Ron,

Let me ask one question first before answering yours, do you know if the subreport is showing summary info, showing summary info for the details that are shown in the...

Is the lack of any response due to this being a dumb question or have i hit on a tough problem that simply has no solution or work-a-round?

Thanks Johnathon I'll certianly gove that a try.

GSquared / Jack Corbett,

Thansk to both of you for chipping in on this one. I'm suprised the response wasn't larger; maybe I'm one of the few who have to...

Jack Corbett (11/20/2009)

---

There is a role, DatabaseMailUser, in msdb that you can put users in.

I'm a fan of option 1 in your case, even though Database Mail is asynchronous, I...

UPDATE:

Well it appears Option 2 'EXECUTE AS' is no't reeally of any use by iteslf because it doesn't appear to work. In my testing, the only values that work...

Thanks Jeff, I figured as much.

Let me ask you this, If i wanted...

UPDATE: The Problem Identified; The Solution Found

After having to deal with this annoying lockup in SSMS 2008 for many months now I finally happened across the problem and the solution....

villersk (11/4/2009)

---

once you have finished registering all servers in your environment and orginanized them you can export the settings as a file and share with others on your team.

- right...

Could you elaborate on that? Proivide an example?