How can I have the security Roles replicated when I setup a Transactional Publication replication?
Currently I have all the data, stored proc, views, indexes, etc... replicated, but I had to create the Roles and assign them to my users to have a working replication server.
Is there a way to include security information when replicating a DB on SQL Server 2005
Thank you,
Eric Lamontagne