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 |
|
redkev
Starting Member
1 Post |
 Posted - 2012-01-18 : 10:25:56
|
| We decided to use transactional replication in SQL 2008 for our data warehouse. Periodically, we need to add articles to one database or another and we have to re-initialize and generate a new snapshot. However, when the new articles are added, the default settings override the existing settings. The two settings we need to persist are "Copy non-clustered indexes" for tables and "Copy permissions" for all other article types. Any help in changing the defaults in SSMS is greatly appreciated! |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2012-01-18 : 14:37:53
|
| you can script out the replication setup and use the script instead of GUI.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Replication Default Settings