post the error messages.

Quite often when a job runs fine locally and does not work on the server, it comes down to permission issues on the data sources/destinations. So...

Adding a ChangeDate would be the most effiect way of doing this,

If that is not possible you could write some T-sql to compare the data in the rows...

use the code tags

-

-

5

false

false

bgfade

207

162

window

-...

it would depend on whether or not the server has been setup with an instance or not.

this part

CONVERT(VARCHAR, M.COMPLETION_DATE , 103) --As COMPLETION_DATE

has the alias commented out try removing the comment marks

CONVERT(VARCHAR, M.COMPLETION_DATE , 103) As COMPLETION_DATE

You say you are using SQL 2000, but this is in the SQL 2005 forum, so you have a copy of SSIS avalaible?

if so, this could be...

You can do this using a script, you will probably need to use SELECT DISTINCT and GROUP BY to remove duplicates. Without knowing exactly what you are doing...

How are you doing the deletes?

when you switched to full-backup mode, did you schedule t-log backups? as it looks like you have run out of room in the t-logs

You should be backing up your transaction log at regular intervals, this will mark the space for re-use and should stop it from growing too large..

Also it allows you...

CTEs were only introduced with SQL 2005 so this code witll not work on 2k.

You should be able to re-write the code to use temp tables instead of CTEs...

as your are using uni-code character you will need to use the leading unicode 'N'

insert into table_1 values N' ????????????

???????

???????

?????

'

also make sure you are using a Unicode data type for...

You can use SSIS to transfer the objects.

But by far the easiest way is to do a backup/restore or detach/attach of the database.

Why do you not have any backups?

Use SSIS to put these Five files into a staging table, and then use the code that WayneS has provided to copy the new data from the staging...

what information do you want on the row, for the example you gave there are values that are different between the rows,

for example the top row has 46, where...