My guess is your log is set to auto-grow in 10% chunks, and it started at 1 Mb. So the first time it grew it went to 1.1 mb,...

I fixed this by moving the code into the Execute SQL task

DECLARE @sql varchar(8000)

--Create dynamic SQL to be inserted into...

Thanks for the input Perry, but I'm afraid that's not it. I run the code in a For Each container and iterate through the databases that way. The...

Is accountdb.dbo.accounts a view? And is *it* using old style joins? If so you need to re-write it.

HTH

Dave J

I've resolved this. I turned OFF Keep together on one page if possible in the properties of the Tablix where the data sits. Why this caused the server...

I've amended my version, please see the updated comments section.

HTH

Dave J

Found this thread and thought I'd post my version for anyone still following it

HTH

Dave J

/****** Object: StoredProcedure [dbo].[usp_Check_DB_growth] Script Date: 06/14/2011 10:14:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

SQL Server Youngling (5/27/2011)

---

Awesome article! Definitely something I've never done, but I believe this article will get me there.

"For an optional solution, please refer to the following URL"

Optimal, perhaps?

And...

Steve Jones - SSC Editor (5/18/2011)

---

My Posts definitely has a limit in how many is shows. It's partially a performance thing, and partially just poorly implemented. Have you tried the...

This is the code needed at the start of block 6, move the balances across. This handles negative amounts.

select acc_no, sum(band_1) b1T, sum(band_2) b2T, sum(band_3) b3T, sum(band_4) b4T, sum(band_5)...

Phew Paul, that's some proof of concept. 😉

I have persevered with mine and while it's not as elegant as yours, it seems to do the job, and as a bonus...

lmu92 (4/1/2010)

---

Please provide sample data that will describe the scenario you're strugglnig with.

Based on your vague description it is unclear whether you would have missing rows in #customers for a...

Jeff Moden (4/1/2010)

---

Sorry David... I've been staring at your latest problem with this and I just don't get it especially since your latest example doesn't actually match with the test...

Kind of. I have jumped on his suggestion but Lutz doesn't move the balances over in the way that I need. Run it for a single account...

Thanks Gianluca,

if you looks closely, that's where my cursor code is adapted from 🙂

The difficulty is moving balances across bands for a given period, so I can't work...