I second the last suggestions, especially if you have separate physical disks available.

You can add a file to the filegroup and the second file will automatically be used once the first file is full.  Turn off the "automatically grow file" setting so...

First of all, a primary key must be defined in the table when using a linked SQL Server table in Access for the table to be updatable.   Access forms are updatable by...

Add a step5 that does identical work as step4.  For step4, make it report failure, on both success and failure.  Modify step2 to go to step5 on success.

This is success:

Step1 ->...

The "Via group membership" option disappeared after I changed the setting.  I thought it was odd as well, but I was just glad the problem was solved!

For step three, in the "On success action" set it to quit the job reporting failure.

select max(myDateField) as MaxDate, min(myDateField) as MinDate from myTable

Just add an alias name to the column, then you'll be able to map it:

Transform Data Task that issues

    SELECT table1.field1, 

           table1.field2, 

           'dbname' as field3

    FROM ProgressDatabase.table1

I haven't attempted what you are trying to do, but it seems like you could use DTS to import the document using the Text File (source) object.  Do a search...

Take a look at the Language setting at the server level, it determines the date format.  US date format is month before day: today is 1/9/2005 or 2005-01-09.  I notice in your...

You can't really join on a derived column because the join happens before the column is derived.  But, if I understand your question correctly this should work:

CREATE TABLE [dbo].[Table1] (

 [someother_column] [varchar]...

You don't have to do all of that scripting.  If you just do a backup, copy the .bak file to CD or tape and then to the second server  and do...

The full backup doesn't affect the transaction log backup size.  For example, if you have a database set to the full recovery model, do daily full backups and forget to...

When you run the DBCC command, does it give an error message or timeout?  Did you do a log backup right before shrinking the log so that the data is...

This is the command I use on our data warehouse db.  A monthly build process causes the log file to grow really large.  This always works, but the recovery model...