Thanks for the replies.  Looking at all answers given (I have a similar post elsewhere) it appears that I can't include the variables in the same INSERT INTO, meaning I need...

Ahhh.

I see you're using the 2nd table trick.

I was hoping to avoid that.

Any other suggestions out there?

If the log file is full, you should do these 3 steps.

1.  Backup the log file.

2.  Backup the log file WITH TRUCATE_ONLY (this is supposed to release empty space back...

Phill,

MSDE can run DTS jobs fine from a licensing perspective.  It just lacks a DTS creation utility.  It's this utility which I'm looking for.

cheers

Danster