moving/copying database

Hello,
Does somebody knows a complete solution for resolving the following issues
when moving or copying a database to another sql server?
- when attaching the moved database, i have orphan users. So i use the
sp_help_revlogin to re-create those users. This works ok.
- when attaching a database which has roles and permissions defined, the
only thing that gets fixed are the logins.
I hope somebody has faced this problem before and can give me a solution.
Thnx
Jason
Here are links to some articles that should help you resolve your problem.
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
Hope this helps
John
"Jason" wrote:

> Hello,
> Does somebody knows a complete solution for resolving the following issues
> when moving or copying a database to another sql server?
> - when attaching the moved database, i have orphan users. So i use the
> sp_help_revlogin to re-create those users. This works ok.
> - when attaching a database which has roles and permissions defined, the
> only thing that gets fixed are the logins.
> I hope somebody has faced this problem before and can give me a solution.
> Thnx
>
>
sql