Can you try to import it using DTS?

Not only sort order, but also you have to initiate and allocate database device spaces and fragments exactly same as the devices in your original server. The device fragments that...

From BOL.

"The snapshot backup and restore functionality is accomplished in cooperation with third party hardware and/or software vendors. These vendors use features of SQL Server 2000 designed for this purpose....

I wouldn't suggest you do that because that process may be shared by many connections from application unless you are sure the idle process is an orphan process.

As long as you don't use for production, It doesn't matter how many CPUs you have.

Or if the snapshot are the MDF and LDF files, you can try sp_attach_db.

Use SET IDENTITY_INSERT to allow explicit values to be inserted into the identity column of a table.

I would copy the data file into c: drive of server and run the BCP from the server. Pelase make sure the data file is able to be opened by...

Your original server name is stored in sysjobs table in msdb. Manually change it with new server name and you will be fine.

RESTORE HEADERONLY command will tell you information about your backup file such as database version, CompatibilityLevel etc. Check BOL for details.

Requesting hot fix is free from Microsoft.

Where does the data file reside, Where do you run the BCP command, in your workstation or server?

As you already done, review the indexes, your delete statement to use correct index by examine the query execution plan. Be aware of changing the indexes may affect other queries...

Do you see "Performance monitor shared memory setup failed: -1" in your SQL Server errorlog? If you are, call Microsoft to get fix and getting the fix is free.

Is sp_change_users_login you are looking for?