August 11, 2005 at 8:40 am
Hi There,
I have a 25GB database which is being replicated. I need to change the fillfactor settings on the index of some tables on that database. When I am doing that SQL Server is not allowing me to change the fillfactor. It says first drop the replication and then perform the re-indexing. My question is what should be my steps. If I drop the replication how should I reenable it ? Do I have to do a snap-shot replication when the reindexing is done or just synchronize the transactions.
Thanks in advance
Ajay Deshpande
August 11, 2005 at 9:47 am
What command exactly are you executing, and what is the exact error message?
Unless you are messing around with the primary key, I don't think replication cares about indexes.
August 11, 2005 at 11:06 am
Rebuilding a index which is a primary key with a different fill factor involves dropping and recreating the primary key and since replication needs primary key i guess its not allowing me to rebuild.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply