"Select Count(*) from ...." hangs on data import

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  January 17, 2007 at 4:10 pm

  #61089

  We are INSERTING several millons records into a sql 2000 table.   During the load process, executing "select count(*) from <the table>" just hangs when executed. Why? How can I measure the progress of the load? Obviously, I'm hoping that successive applications of "select count(*).." would return something like : 1000, 2345, 7895,, 15,234 records. etc.

   

  Thanks,

   

  Bill

   

   

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 18, 2007 at 12:02 am

  #683911

  May be your load process holding the locks on the table.

  run your script with

  MohammedU
  Microsoft SQL Server MVP