Import export wizard (not working) goes in hung state

• mjafar

  SSCommitted

  Points: 1539

  More actions

  January 16, 2008 at 3:03 am

  #185685

  Here I m trying move data from one table to other table in same database.

  There were total 20 tables, out of which data of 10 table has been moved.

  But right now when I am doing same thing of import data from one table & inserting it into other table of same database process doesn't work.

  I think it goes in hung state.

  but when check sp_who2 active it shows that this process is sleeping.

  I try it for multiple time. (before I do next I killed previous import export process). Still not working.. I just refreshed my services.

  what should I do..?

  Can any one suggest me...

  Regards

  Majid

• mjafar

  SSCommitted

  Points: 1539

  More actions

  January 16, 2008 at 3:23 am

  #768534

  I think transaction is getting blocked..

  But why this is..

  How do I resolve this..