Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nejc
Starting Member
17 Posts |
 Posted - 2005-08-24 : 03:01:00
|
| I noticed that when i use snapshot replication, whenever i transfer a new snapshot to the subscriber, it ruins the permission settings (they just appear blank on the subscriber after replication). I came up with a temporary solution - using a script after replication, but i was just wondering if it is possible to do it without the script. Is there an option or a command to add to the job step or something else to do the same trick ?If not, then i guess the script will have to be ok.Thank you. |
|
|
nejc
Starting Member
17 Posts |
Posted - 2005-08-24 : 03:23:33
|
| well, i found that:[url]http://www.mssqlcity.com/FAQ/Replic/replicate_objects_permissions.htm[/url]Now the question is, how do i replicate a system type table ? They do not appear on the list when i try to set up a snapshot replication. |
 |
|
|
|
|
|
Replication and permissions