You could set up Snapshot Replication to run on a daily basis. As part of the replication configuration turn off the copy of the indexes at the Article level but also define a post-snapshot script that would run to create the MI specific indexes that you want.
================================================= We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry
Schedule copy of db then add index
Posted - 10/15/2012 : 15:26:53
