December 15, 2010 at 2:23 pm
Is there any way I can see how far along an insert statement is? We are getting ready to insert 15 million rows from one database to another and I would like to know after a couple of hours how far along we are.
Thanks
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
December 15, 2010 at 2:29 pm
How are you doing the insert? With that many rows I'd suggest BCP.
For progress, a simple way would be to do a
select count(1) from table with (NOLOCK)
where insertcriteria
on the table in question to see how many rows are there.
Not 100% reliable but it'd get you something.
If BCP isn't an option, you could always do the insert in batches using TOP and an order by on your insert into ,,, select ,,, statement.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply