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 |
|
imakimak
Starting Member
2 Posts |
 Posted - 2011-08-10 : 15:43:37
|
| I have an existing table in a replicated environment, I know there are restriction on schema changes that can be done on this table. Can I do the following.1. Add a unique constrainst on publisher and will it replicate to subscribers?2. If there is an existing unique constraint on that table, can I modify it on publisher and will modification replicate to subscribers? TIA |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-10 : 18:53:53
|
| Need to apply the constraint at both the publisher and subscribers if you want it at the subscribers |
 |
|
|
|
|
|
Add/modify unique constraints on replicated table