I killed the process and I am going to schedule a failover of the Cluster so I can stop and restart SQL Server Instance.   Thank you for the Help!!!

looks like I have a long running process..  dbcc check database from sa against the database that is having a problem. !!  not sure how long this has been running.  ...

Great!   Thank you all so much for the input!

Thank you so much for pointing me in the right direction.

The table does have a unique index and it is based on column Vantive_ID and does not allow duplicates....

So far I can see that tblMACD has a unique  index called idx_tblmacd_1 based on column Vantive_ID that tblMACDBilling does not have

Thank you one and all !!

Thanks much. So I'll go ahead and make a copy of my table for safe-keeping and then use ALTER TABLE and DROP COLUMN

Thanks.

Thank you all. I think between the sql diag tool, DBArtisan and NT Perf monitor, i can gather what I need. I'm keeping my fingers crossed on the...

My boss has a couple of temporary licenses for the embarcadaro software.. he's setting up a demo for the powers-that-be to try and get...

wonderfull! looks like a pretty slick tool!!

thanks everyone for your help and input!

are you talking about sql diag manager from idera??

I download an eval version yesterday - nice tool but i can't figure out...

awesome. thank you very much!

Thank you everyone!

Thank you so much! why I didn't think to truncate the table to preserve my indexes I have no idea.. I'm pretty new at this. oh well, ...

so... export (dts) the table data to a new (temp) table and then truncate the original before importing (dts) my flat file into the original. I...