DBCC (urgent!!)

• PEnnenga

  SSC Enthusiast

  Points: 100

  More actions

  May 22, 2002 at 2:56 am

  #157906

  I am running an DTS package to transfer an table from one database to an other. The databases are located on the same server. The table has a size of 4 GB. I dont know why it takes such a long time to be copied. When i check sysprocesses i can see a block on a DBCC command. Can someone explain why there is a DBCC command at all in the background. The waittime for this proces is enorm.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 22, 2002 at 5:02 am

  #429581

  Please do not crosspost. See responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4370&FORUM_ID=5&CAT_ID=1&Topic_Title=DBCC+%28urgent%21%21%29&Forum_Title=Administration

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)