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?

WOW! Great replies; the perfect reason why I love these Boards!

First off thanks to all for replying. Seen several great tips in various posts, some of which I...

Jeff Moden (10/20/2009)

---

I know that the use of cursors and loops for flow control is an acceptable use but... I just can't bring myself to write one if there is...