Thanks Gunneyk and rm.
I managed to script the login, password and roles from using http://support.microsoft.com/?id=246133
I also realised that the application vendor had created tables in tempdb in sql2000.
These tables are needed for their application to run. I am puzzled why would application vendor want to create tables in tempdb and not in their customized database. The tempdb is usually not backup right ?
What is the best way to bring these tables about 10 of them including the records from sql2000 tempdb to sql2005 tempdb ?