If Jason's right, and you don't have enough space, then you have to modify your job to delete your old backup first.  I ran into this in one situation. SQL...

I remember uploading to an AS/400 from SQL2000 without much trouble (never used SQL7), but we don't have the AS/400 now so I can't test anything. Are you loading into...

I don't see any problem.   I replicated from TableA to TableB, where TableA has 4 fields and TableB has 5 fields. It replicates the 4 fields available. You can also...

Thanks .... Using a dummy SP for the deletes worked, but using NONE is a lot clearer.

Yup .... It will work. I was experimenting with that very thing just now.  I encountered a problem when rerunning the snapshot that I'm about to post in a new...

I've used Lumigent to restore tables, but if your DB is manageable, and you have space and a good backup, it easier to just do a restore & DTS.

Stored procedures contain SQL scripts, and then one Stored Procedure can call another.  Is that what you're getting at ?

You're doing this in a DTS transformation step ??

If so, I've had success converting dates a different way.

When creating a "New Transformation", choose "DateTime String" , then "Properties". Then you...

Or post it here if you think it would be useful to others !

As Kenneth said, be careful if it's a large table, especially in a production environment because you may create locks on the table that will affect other users of that...

" ........ almost every post gets answered within 5 to 10 minutes...  "

" ....... I think I heard my name in this thread ......."

Remi ....  sushila gets credit for some...

I seem to recall that happening to me a while back. I think I detached the db, reattached it, then everything was fine.     Not sure why

I usually write each job step out to a text file. It tends to have more useful information & doesn't get truncated.

Open the job, then go to each step, then...

Kenneth, what about leap years ?

If you have the script, just create a new job on the new server, and paste the script into it. Then schedule the job to run at the desired time. ...