>Good idea, I'll give it and SQL Passthru a try to see what is quicker. Thanks,
> Doug
Unfortunately neither will be as fast as DTS because they both hit the SQL log (unless you have logging set to simple). DTS does not log changes so it should be the fastest method.
I'm not particularly thrilled with DTS error communication, for the exact reason you mentioned. It SOUNDS like you shouldn't have any problem. However, you might have maxed out the DB file space (although I think you would have gotten a more specific error) or run into some other odd thing (like maybe a backup kicking off when you tried to do the transfer).
Sorry I can't be of any more help; this sounds like one of those 'you gotta see it work' type of problems.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
