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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-06-19 : 01:55:41
|
| Dear All,is it ok to run index rebuild script on publisher and after that in subscriber? what are the steps i need to take to do this?will it affect the replication? please help me here.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-19 : 03:16:31
|
| No, as long as there are no changes to the index (which I guess there aren't as you are only rebuilding it), then there will be no problem running this.Use ALTER INDEX with the REBUILD option. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-19 : 04:32:44
|
| can i have a good code from you for index rebuild?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-21 : 17:55:21
|
| Take look at 'alter index' in books online. |
|
|
|
|
|
|
reindex script in replication environment