August 20, 2007 at 2:30 pm
Ok, this may be a silly question, but can a table itself be designated not for replication?
I have to create a permanent table for managing the indexes on a database, but down the road if replication gets rebuilt which would get done by someone other than me, the processes we use would add the table to replication which I don't want.
August 21, 2007 at 9:14 am
There is no property or attribute for a table object that would tell replication not to replicate a certain table. With that said there are certain attributes of a table that would not allow the table to be published such as the lack of a primary key. Alternatively you might change you process to only include tables owned by dbo and have you index table owned by another schema or you could start say an admin database and put your index table there.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply