Hello Rootman,

great it works!!!!!!!!

Thank You!!!!!

Mark,

he cant be owner of the job because the job needs to run as NT/administrators.

hello,

i suggest you should correctly shrink your DB. That means, you alternate shrinking and Backups until the free space is 0.

Then have look at the real size

we are testing since some days the difference.

And we found out that it is not a problem of collation or tempdb but it depends wich account started the job. On both...

Angela, Gary

when we run on server 2 the dts manually to import tha data, the collation is correct.

When the dts runs as a job the collation is wrong.

It s very strange!

Gary,

thank you for the response. Strange is also that yesterday i migrate the DB from server 2 (bad one) to server 1 with a different name and the same trouble appears.

Hello Angela,

we import the file with a DTS. Strange is that the developper told me on server 1 he runs the dts manually from his machine, on server 2 the...

Yes it s exactly that concerning the collation of both servers.

we import a text file.

I give you an example of query results

server1:

Mener à terme l'étude

server2:

Mener Ó terme l'Útude

correct is server1

Anybody...

Thank you Allen

thanks to all, that seems to be the solution

:=)

Great Proc,

it works very fine!

Thanks

there is a tool "DTSBackup 2000".

With this tool u can backup, transfer dts

from a server to another one

hello together,

i found out that i had to replace the MtxOCI.dll with another version.

And it 's work now

yes it is still in the outbox from outlook

and i have to start outlook and then the

mail is going out...

I work with the FTP task and it work properly.

1) you should test if the server where you

sql server is hosted can connect to the ftp

site. (type in your browser...