It's pretty simply laid out here:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

If I were you though, I wouldn't even consider it. Put it on your dev environment and copy the db across, get...

Interesting.

Are your sysadmin permissions granted through a domain group, or is AD\User a member of sysadmin?

Theoretically this shouldn't matter though. You're cached details will still have the relevant tokents...

Absolutely.

This is referred to as a side-by-side installation. Simply choose a named instance when you are installing SQL 2005 and your SQL 2000 server will be untouched.

Expand the SQL Server 2005 database in SMSS then > Programmability > Stored Procedures

Right click your stored procedure > Script Stored Procedure As.. > CREATE To > File...

Run this script...

Something wrong with upgrading?

Stick in the 2005 CD and install a default instance, you'll be prompted to upgrade, it'll remove the old binaries afterwards.

If it meets your requirements* then yes. You can later upgrade to Enterprise.

*Feel free to post up what these are.

What's the story with international applicants?

Changing the schema owner is not a problem:

ALTER AUTHORIZATION ON SCHEMA::schemaname TO newusername

I read the NDA on the exam on saturday, and it is not clear what I'm allowed to talk about, though obviously, no question details.

There was far too little time...

Wrong forum.

You'll find that the published date is set in the future.

The only good one I've found that is available now is Changing the Paradigm - isbn 0672327783

It's under Client Components on the Feature Selection page (Advanced button) of SQL Server 2005 Setup.

You dont need to reinstall the whole thing, you just need to select the Legacy...

You need to install Legacy Components.

Go to Add/Remove, click, Chcange ,go through to components and select Legacy Components.

Any feedback on these exams yet?

What's the format like? How different from the 2000s?

I can't see why it wouldn't, but the question should really be; why do you want mixed versions?