Thank you all.

It does seem misleading that the Memory tab in Server Props shows all the RAM on the box though ...

I suggest you look here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;826433

(this article lumps errors 605 & 823 - and others - together, as Grasshopper alluded)

http://support.microsoft.com/?id=231619

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23lh.asp

Good luck!

BMc

DTS Package has two Global Variables, one ActiveX Script task, one Execute SQL task.

Global Variables:

gFolder (the root folder of the backup files)

gFPath  (the dynamically determined path to the backup...

Alex,

I just wrote you a long, detailed message with my code, but lost it when I clicked Preview. Hopfully I'll have time to create it again soon.

Sorry. I'm bummed.

Bruce

First off, I wouldn't modify the jobs used by a DBMP. Once you do that, SQL squawks if you go back and try to modify the MP, itself.

I do a...