I am trying to figure out why I can't access the DB that I've replicated. Two tables have a key with a red x that makes it so I can't publish them for replication. In addition, how do I replicate all the user roles and permissions with the database
that is being replicated? I am using SQL Server 2000.
More info: I can't access the replicated DB through the client software. It is accessible through SQL Management Console. I had to manually export all users and roles and then run the query to get them into the replicated database.
Is there a more thorough way to replicate a database? How can I make an exact copy on a different server so all information is intact?
View Complete Post