I got some conflicting ideas from people at MS. Someone was going to try and dig in (and blog) on this, but they've been out of the 2000 code for...

I'm slightly confused. Do you mean 2 drives as in 2 LUNs? Or 2 physical drives?

If tempdb is used a lot, it could benefit from a separate LUN, but it...

Does this help: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=598396&SiteID=1

http://support.microsoft.com/kb/328354

I agree with Yvan, but the short answer is you can't stop someone with sa or sysadmin permissions from changing the objects or permissions.

It really doesn't matter how it was installed. This an administrative license only. What matters is that you have the administrative licenses in a file cabinet and you are abiding...

#2 first: User sp_changeobjectowner to reset the owner of the new table to Lester.

#1: Did the db originally have 2 files for each? Lots of people like this, makes it...

Do not put your logs on a single disk. Keep it as a hot spare, let performance suffer and someone will eventually spring for disks.

Hardware is cheap. You've probably blown...

Hard to say on that, but everyone seems to be recommending quad cores where possible.

Same OS/ SQL versions?

That sounds a little suspicious, but you've got less threads executing simultaneously, so it might make sense.

Yeah, offline would be better ;), didn't think of that.

I'd do autoclose or offline because that way the db still is on the server, it keeps it in your mind,...

sysobjects.uid

Profiler will do it. Autoclose is a quick and dirty way to check. Easy to scan logs, don't have to remember to turn it on, etc. If you're not experienced,...

Use the Unicode character instead?

Directly pick the character using CHAR(xxx) where xxx is the right code.

I've seen in the Scheduled Task items that if you schedule it to run for 2 hours, even though you say every hour, it only runs once or twice.

As for...

Are you running them all in the same batch in both situations?

You could try a stored proc instead and use WITH RECOMPILE.