SQL Server 2000 database upgrade to SQL Server 2005 the fastest

After you install SQL Server 2005, you can attach directly to the database files created under SQL Server 2000, whether they are 32 digits or 64 bits. The quickest way to upgrade your database to 2005 is to detach the database in SQL Server 2000, copy the database files to a machine that has SQL Server 2005, and then attach the database to Management Studio, where orphaned users are attached. You can associate orphaned users with database users with the following statement:
Sp_change_users_login ' Update_One ', ' Test ', ' test '
This will reconnect the server login "Test" with the Northwind database user "test".