select from sys.databases?

Keep in mind that even with simple mode, the log can grow. If you don't break it into batches then each delete is logged, which can be a lot of...

I haven't seen anyone reporting issues with Resource being corrupt and needing to restore. Since you can just copy the same DB from any instance back to your server if...

The resource database tracks system objects at a particular SP level. The actual DLLs and SQLServer.exe are changed with the SPs, so you would need to uninstall/reinstall, as George mentioned.

I'm not sure I agree that SET ROWCOUNT is the issue in SQL 2000. I've used a similar method years ago in 2000 to delete large numbers of records and...

Yep, if you read the article they mention that they make heavy use of Windows 2008 R2 and HyperV

That means that you don't have any logins and users out of sync.

How did you move the objects?

Sorry, if you didn't detach/attach, how did you move the objects?

If you copied them over, the permissions aren't there. You can use the Generate script function of SSMS to move...

All your user permissions and objects will get moved with an attach. The only thing that you might be missing is the logins. sp_change_users_login with the report option should help...

Read this:

http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/

tempdb doesn't write sequentially. The best thing you can do is separate out tempdb if it is getting used heavily.

If settings are not mentioned, assume the US English defaults.

DR is a good point.

As far as a target, that's possible, but this is an R&D lab. Presumably there is no issue for the company running if it were to...

My son reads the editorial scripts at times. He asked me what "it" was and why did I capitalize it?

Terrible shirt?!?!

If you get errors from DBCC, I'd start a new thread in the data corruption thread and post it there.