I've done a DROP TABLE as the first task, then a CREATE table, then the transform. 3 tasks and that's worked.

Will,

Very strange and thanks for the updates. I'm doubtful on new drivers myself, but you never know.

If you have the space, I'd ask for new drives from DELL as...

Couple other things to add.

First on licensing. Single license per machine for SS2K5. If SS2K, you need Enterprise to run unlimited. Standard requires separate license. Lesson here, upgrade one...

We only show those posts that have had activity in the last day. So while it may seem you see the same ones, it's because they're receiving new posts in...

Glad to see there's at least some interest.

I'm not sold on global warming myself, nor am I a rapid environmentalist, but I think it makes some sense to at least...

Michael,

Sounds like you're the Stealth DBA , or maybe the Ninja DBA

Nope, my big ol' tractor + my wife on a riding mower. I need to take a picture. Still probably got 4-5 acres left, but it's raining, so my aching...

Well said Narizz28!

That's cool. I should show some of this stuff on the site.

As an afterthought, I got to cut a lot of grass, about 15 acres over the weekend, but I did put my flag at half mast on Mon morning. The...

Anders, didn't think about that, but I'd assume that someone would not take another call and finish this one. Especially as we'd spent time going through things.

I do think it's...

It's on the way. It's a pretty good amount of change because of some old code, but it's being added to the rewrite site.

Adam has a good explanation, but I'll add mine:

Statistics are a way of guessing what the distribution of data is in a column. So if you have age, SQL "samples"...

you might be able to do this with a data pump, but I'd follow Lanny's advice. It's easy and quick. Import into a staging table and set up a proc...

Call the hardware vendor? Is it a name brand for the box?