I changed the qry to this to aggregate it better.

select

SUM(cp.size_in_bytes) / 1024 / 1024 As sum_SizeInBytes_MB

, COUNT(*) As Cnt_plans

, DB_NAME(st.dbid) AS DB

from

...

This is easier to do at the client level.

Send the data order by Client, date

while not rs.eof

while client didn't change, addcolumns

change row

wend

I think this is worth posting a connect item on this to MS.

What query did you use to find the issue?

P Jones (8/1/2011)

---

It's not the agent job I want to change, there's a hundred subscriptions on the one agent job and none on others so I need to even it...

Ray Mond (8/1/2011)

---

Ninja's_RGR'us (7/29/2011)What do you do if that tlog backup doesn't pass verification right after you take it? How can you undo / redo that whitout stopping the...

His name is MysteryJimbo. Addicted is based on his # of points on the site.

Ray Mond (8/1/2011)

---

Ninja's_RGR'us (7/29/2011)What do you do if that tlog backup doesn't pass verification right after you take it? How can you undo / redo that whitout stopping the...

How much space in the plan cache are you wasting on those plans? This might be worth it to create a connect case with ms so they fix...

Lowell (8/1/2011)

---

Yes Ninja absolutely GMail works; the only wierdness is the alternate non-"25"...

You just can't export to excel 2007 in ssrs 2005 (unless maybe you bought a plugin from a 3rd party vendor).

The file will be in excel 2003, which you'll be...

One test I'd try is to go to the sql agent and change the schedule there. The only problem is that as soon as the user goes back to...

Hey lowell, can we really use gmail for this??? Would be really awesome if it worked!

David Paskiet (8/1/2011)

---

DUH! Why is it the simple answers go right past us. You are absolutely correct and it works like a champ. Thank you for the...

What plans do you see in cache for msdb? Maybe you could change some of you jobs to use sp_executesql with parameters instead of exec().

That could cut it...

Yup, what I usually do is build the restore command from SSMS GUI,...