• s_detach_db/sp_attach_db or backup/restore.

    For login/password transfer, See http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql2k