ya, I had actually thought about that. I still have the scripts and format files from a previous bcp we had done.

Indexes were actually dropped and rebuilt a week ago. There are daily bulk inserts, so it's possible they need defragging weekly.

thanks for all the info.

I ran shrinkdatabase and it still wasn't finished after 42 hours. I had to stop it to get the app up and running again. ...

I just had similiar problems with pageiolatch_sh.  A query took 30 minutes to run.  I found an index problem, dropped it, rebuilt it and bam, query runs sub 60 ms...

Beautiful!  Thanks.  I've been stressing over a very heavy logic oriented script.  I should of thought of this.

I am still having problems.

declare @intserialnumber  int

declare @myerror  int

set @intserialnumber = cast('MNO0101             ' as int)

select @myerror = @@error

print @myerror

Once the cast runs, I get the error immediately.

Do I get the DTS Designer where I can do all the transforms etc.. in the standard or is this just a "wizard" that you speak of?

Just an observation, last night I saw on the news a generator mounted at sea level in Alabama.  It was half underwater.  I sure hope it wasn't considered a backup...

Without leaders, they wouldn't have brought together the right kind of people to make the business succeed like you and I.   

IIRC, this was in Virginia, USA.

For one of my web sites there was an underground fire and the fire department forced my host to shut down everything.  We were out for 24 hours.

For me, I...

I've run a couple defrags at the os level with sql2k stopped.  It defragged one smaller 800 meg db ok, but on the 22 gig db it wouldn't defrag the...

How could I forget?  I had done this once before, maybe because it's production I am more worried.   Thanks!

anyone have any ideas or suggestions?

I use MRTG and performance counters logged to a CSV file, plus several home grown scripts to put it all together.  MRTG creates the graphs.  With the CSVs, I can...