yes

There are scripts in the script library here as well that might help. Search blocker or root blocker.

I'd check and be sure that your statistics and indexes are up to date. Rebuilding indexes will update statistics as well, so I'd do that.

Can you narrow down where the...

What do you mean? SS2K only has precision to 0, 3, or 7 ms as the final digit. You could build a UDF to round those to what you need,...

You could get a log reader and read through it. Log Rescue from Red Gate works on SS2K and it's free.

What are you trying to do? You can create a temp table and assign the output of the proc to it.

Can you not perform the join in the proc?

anything in the error log? Perhaps run a trace overnight to look for things?

HAVING is probably what you want, but please post some examples and let us know if that works or doesn't.

Why not use BCP or SSIS? The wizard makes this easy and it would be smoother than VBS.

you can create a role in msdb in 2000 and I'd recommend that.

Be sure to include it in your DR planning as this would be needed in a rebuild.

Let us know how it goes. This was an interesting discussion.

I think you need to stop looking at design because people are always in a hurry. The developers don't want to do a bad job, but they want to get...

Great editorial, Ted, and thanks for the day off (sort of) 😉

I have a friend who's an anesthesiologist. People will hear he's a doctor and ask him about something, and...

Points are awarded back.

Apologies for the delay. I was on vacation and this was one thing that no one else knows how to do (yet).

The run through of the question...

Sounds like the EM instance is broken. Does this happen against any server instance or just the MSDE ones?