Reindexing does not update statistics. Use sp_updatestats, or turn on Auto Update Stats in the db properties. -JG

DTS, Data Transformation Services. Use the import and export wizard and it will walk you through all the details. -JG

See dbserverenum in Books on-line. -JG

Steve, that was the solution, in addition, I had to use MoveFile instead of Move.

objFSO.MoveFile(strFileSourec, strDestination)

Thanks for the Help! -JG

Edited by - jgee on 01/11/2002 11:53:50 AM

I MsgBox strFileSource and strDestination after the IF nad it returns the correct path for the file. very Strange. Still at wits end. Let me know if you see anything...

It errors out on the .Move line. Stating: Object required: 'strFileSource'

I am taking your advice on backing up and moving the file to the server then performing a restore. I am having trouble with the FileSystemObject Move. What do I...

Are you talking about the last ten statements? I would suggest using Profiler to capture what you are after. -JG

I had to copy over the MSDesigner98 folder then re-install SQL7 and SP2. Probably could of got by just re-applying SP2 after I copied over the folder, but this did...

From my experience; is'nt it optimal to send the results to a file, then save it to a SQL table? Seems profiler writes faster to a file than a table....

Try sp_MSforeachtable It is a system sp. -JG

Not sure about your specifics on using a text file, but one option, you could create your statements and call them through the ISQL utility. There are a few more...

I used to be a Systems Engineer until I migrated over to the DBA role. I really enjoy it! Being a good DBA allows you to use all of your...

I agree, the attach and detach technique is fantastic for manipulating the files. -JG

I agree with you Steve. I had no idea there were a lot of quirks in DTS. The one post on using other tables and pumping out emails to monitor...