fragmented .mdf & .ldf files? I would suggest backing the databases up, then drop them and delete the physical files, create some new database objects in their place with...

two slashes is fine for unc paths if your moving stuff across servers, like in this example. And as pkirk suggests, check that the sql service accounts (run services.msc...

Yeah, I use UNIX2DOS & DOS2UNIX, very handy little utilities.

I would check to see if the sqlagent service (and maybe also the MSSqlServer service) is starting up using the local system account which may not have suffiecient permissions...

It's not a problem with DTS at all.  The data is loaded in same order as on the source file.  It is the select that displays the loaded text file...

I have found a work-round for now.  It's not perfect but it does the job.

I can use DTS to import the textfiles into an access database with an...

Thanks McCork, it's sorted now.

I ran:

DBCC OPENTRAN (images) --check for open transactions>none were found

DUMP TRANSACTION images WITH TRUNCATE_ONLY, NO_LOG --flush log file

USE images DBCC CHECKTABLE (syslogs) --check log size>614Mb...

I've also been using these types of .bat files for a short while for production rather than admin purposes. I've recently had to transfer all my print & file...