Hi,

I am trying to bcp out one table from one server to
another server:

bcp "dbname.dbo.tablename"
out "\\remoteservername\remoteserver_SHAREdrivename\bc p
process\tablename.txt" -Sremoteservername -N -T
I ran the code in command promp.

this table only have 600,000 rows, but the bcp log shows
that it has bcp over 700,00 rows and still going!! I had
to kill the process.

What's going on?

many thanks!!

JJ

It's worth double checking how many rows are in the table :-

SELECT COUNT(*) FROM tablename
sp_spaceused tablename

--
HTH
Ryan Waight, MCDBA, MCSE

"JJ Wang" <anonymous (AT) discussions (DOT) microsoft.com> wrote