Try building your edge table in tempdb instead of using all the unions.  Also, maybe a call to an XSLT in the template or in the final xml result might...

Bill,

Arden is right on the money, I've seen Access database shrink by this factor.  So try the built-in tools.  The cause as IRC is that really never internally deletes records...

You might also try the DTSRUN.EXE tool.  IIRC, It doesn't require you to have EM to run a package.

Peter Evans (__PETER  Peter_)

Bill,

Have you just tried using the Upsizing Wizard built into Access 2k?  It creates a nice report of how it converts Access Types into SQL Types and reports problems.

Peter Evans...

T-SQL approach

-- Assuming you

-- CREATE PROCEDURE spGetNextReportDate

--  @resultsring nvarchar(8) OUTPUT

__ AS SELECT @resultstring = ...

declare @nextreport nvarchar(8)

execute spGetNextReportDate @nextreport OUTPUT

insert (column1, column2)

select ArchiveColumn, @nextreport...

Nice introduction to the concept of NULL is unknown.  But I disagree with the implication that NULL should be treated as some default value.  Yes sometimes treating @variables as defaults...

You might try the Database Maintenance Plan Wizard built-in to EM and-or the sqlmaint.exe command line tool. I think these will post the size information you might be desiring...

You also might want to have your DBA set you up a DTS (Data transfromation services) script that you can run independently with DTSRUN.exe tool and load the data directly...

Are you sure your not running sql server in single user mode?  I've seen this error when I've had sql server running in command window under single user mode for some...

I agree with Grasshoppers post.  I think you're creating work for yourself here.  However, If you just have standard edition maybe that's why you needed todo the work by hand. ...

Why aren't you using DTS packages to distribute the jobs and as documentation?  Are these not sufficient for your business logic needs? 

The DTS repository can be used for this...

With so many new features, YUKON (Sql Sever 2005) needs to get them very stable and secure before releasing regardless of the other licensing programs Microsoft customers have purchased. 

I...