Paul White NZ (5/5/2010)

Sounds all too familiar. Work sucks - and almost everywhere is the same, eventually.

Have I cheered you up at...

Looks about what I came up with, just not formatted the same.

Does this query now return your expected results?

Cross post, please respond here.

Please don't cross post, it will only fragment responses.

So you are saying you don't have the t-log backups,...

Because your WHERE clause is essentially turning the OUTER JOINs into INNER JOINs. Move the criteria from the WHERE clause to the appropriate ON clause in the OUTER JOINS.

And...

tosscrosby (5/5/2010)

Just...

SQL Server 2008 Express has had the maximum size of the databases increased from 4 GB to 10 GB.

Start by looking at all your queries. Realize that tempdb is...

Help us help you. Please provide the DDL (CREATE TABLE statement(s)) for the table(s), sample data (series of INSERT INTO tablename statements) the represents your problem domain, expected results...

Yes. If you are using any SQL Server 2005 EE features, you won't be able to modify those objects on the SE, iirc what I have read.

It would be nice if you were more descriptive in asking your question.

Yes, a database using the SIMPLE recovery model can still have its log file grow. it is...

Of course, after I post my answer, I have to come back and ask you for clarification as to what you are trying to accomplish.

If you have all the transaction log backup files since the full backup you want to use for the restore, yes.

Have to ask, any performance issues regarding queries and reports? Is your only concern that the system is not using all the memory available?

Your welcome. I'm leaving as an exercise to you turn the code into an inline table valued function (it will perform much better than a scalar...

Table valued functions can not cause side effects. Using dynamic sql inside a function could violate that...