Replicating roles

Hello,

I use a merge replication between Sql Server and Sql Server Express.

When I enable a DB for .NET features (eg RoleManager), I have new tables and roles that are created and some GRANT are given on SPs.

When I replicate these DB to another one, none of my roles are replicated and I also loose my roles. Is there a way to replicate also the roles and the permissions ?

Thanks

Pierre-Emmanuel Dautreppe

use a postsnapshot script for this. if you deployed your subscription through a file copy (unc), you could package up the permissions in a script and use sp_addscriptexec to replicate this to all of your subscribers.