Migration from Sql 2k to SQL 2k5 - Questions

1. How do I copy all my sql logins with their password from sql 2000 to 2005?
2. How do I copy all my Jobs from 2000 to 2005?1) http://blogs.msdn.com/lcris/archive/2006/04/03/567680.aspx
2) Re-create them
"âì" <@.discussions.microsoft.com> wrote in message
news:BC62FC5B-6297-4865-AF56-BD32F93B0C0C@.microsoft.com...
> 1. How do I copy all my sql logins with their password from sql 2000 to
> 2005?
> 2. How do I copy all my Jobs from 2000 to 2005?
>|||Hi
To add to Uri's answer
"×?×?" wrote:
> 1. How do I copy all my sql logins with their password from sql 2000 to 2005?
Also check out http://support.microsoft.com/kb/246133/
> 2. How do I copy all my Jobs from 2000 to 2005?
>
You can script the job(s) and then re-create the job from the script.
as described in http://support.microsoft.com/kb/314546
>
You may also need to resolve orphaned users see
http://support.microsoft.com/kb/274188/
John