Copy Database Question

Setting up a sql2005 db server, trying to use Copy Database to move from sql2000 to sql2000.

When I use the copy database wizard it does copy the tables and logins but it does not appear to be copying the permissions (like db_datareader, db_datawriter, db_denydatareader, db_denydatawriter, etc.)

What could I be missing?

Thanks

i could never get Copy Database to work when migrating to 2005. i ended up detaching the database and copying the mdf to the new server and re-attaching.|||

The Copy DB wizard does not copy all metadata from one server to another. Check out this article:

http://msdn2.microsoft.com/en-us/library/ms188664.aspx

Specifically, this section that tells how to migrate everything else over:

Managing Metadata When Restoring to Another Server Instance

When you copy a database to another server instance, to provide a consistent experience to users and applications, you might have to re-create some or all of the metadata for the database, such as logins and jobs, on the other server instance. For more information, see Managing Metadata When Making a Database Available on Another Server Instance.

Thanks,
Sam Lester (MSFT)