I have this between two dbs as well and homebrew's solution works good.

However if I did much tempdb work, I'd change that collation to match the db that gets used...

And you need to fix the hardware! It's a problem that tends to get worse.

What the problems you're experiencing? That might be the first step in getting advice. I think both platforms perform well. It's more a matter of the application working well with...

A little late to the game, but why are you trying to attach the MDF across the network? Maybe we have a better alternative.

Where are you located?

Great point, Hugo, and I agree. You do want to know about reads.

I hadn't thought about comments, but that's a great point as well.

Rebuilding indexes is something you need to do after big changes in data. Since you truncate first and then load, you should be OK.

You might drop all nonclustered indexes for...

If you need help to generate an ICS file, you probably need to go to an Exchange or .NET site dealing with mail. Once that is done, we can help...

I pinged Dr. Andras. FYI, he worked on the Log Rescue tool.

I'm with Jeff, what's undocumented? The (#index)? That should be ok.

Actually the point of RSS is to get you a bit of the content so you can determine if you're interested. If so, you should click through the links. Authors...

Ah,memories. I used to have that box in my cube. Right next to the OS/2 manuals (insert shudder here).

Anyone remember the "probe" user?

There probably is. I know some companies licensed code from MS to decode that stuff. Not sure if it's out in the wild yet. I'll ping a few people.

Actually it's April 8 for 2000. And that's the end for mainstream support. You'll still get security patches and you can pay (through the an orifice) for extended support after...

On the questions from MudLuck.

It's kind of an unofficial policy from Microsoft that they'll support at least 2 versions of a product. However with their product cycles, and being $$...