It is becuse of the PK cluster index, the same happen to me , my solution is always,  when i want to copy alot of record drop the index and...

Make a cursos for all the tables in sysobjects

use this query to compare

SELECT *

from database1..Information_Schema.COLUMNS

where Table_Name=@tableName 

The same happen to , have you try install SP4 for sql server

agree with pokitlok I always do the same. but some times I use temp table , must of the time to avoid cursors.

So you are saying that the suscriber are in the server too ?, can you explain a litte more about your suscriber and publisher. How can you have the Agent...

Does any of the process running is this servers use temporals tables ?

It use to happen to me that a store procedure made for a report was ussing temporal...

On my experienci i'm ussing rar instead of zip , it compress more that zip. The bigger file that i have compress is 55 GB. Who big is yours ?

After you saved on the .bas file VB file. what do i need to do to imported in another server ?

You need SQLserver 2000 developer edition. Standar and Enterprice editions are for server only. Developer edition have every think on it.

What i use to do is run a command line like this

d:\

cd "my files"

Copy *.* allmyfiles.csv

and on the DTS you conect to the allmyfiles.csv

after execution delete the files.

like this.

d:\

cd "my...

copy /?

/B binary files.

Funny thing you are right , never notice this.

use this

copy E:\temp\Fi*.txt = E:\temp\Coll.txt /B

i would work.

We have the same problem , what we use to do is to run a command like using the stored procedure

EXEC master..xp_cmdshell

calling the http://FTP.exe program.

we made a...

SELECT *

FROM a,b

WHERE (A.FNAME = B.FNAME OR A.FNAME = B.MNAME OR A.FNAME = B.LNAME OR

   A.MNAME= B.FNAME OR A.MNAME= B.MNAME OR A.MNAME= B.LNAME  OR

   A.LNAME= B.FNAME OR A.LNAME= B.MNAME OR...