Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Does BCP write to any tables/logs?

Author  Topic 

pug2694328
Posting Yak Master

166 Posts

Posted - 2006-09-12 : 17:46:46
If I'm using BCP to insert a very large number of rows, is there a way to get a count of the rows already inserted?

I don't know the table rowcount before BCP began adding rows.

I.E. Is there a way to monitor the BCP progress?

Thanks for any help you can offer.

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-09-12 : 17:52:21
If you're executing from the command line, it will give you progress reports after inserting x amount of records. Have a look at the command line options because you may be able to specify this (although I've never tried it).

HTH,
TIm
Go to Top of Page
   

- Advertisement -