• Good article. Didn't see it mentioned but Non-Clustered indexes are not created on the subscriber automatically. When you view the article properties, you would need to select this option. Some may not need them, but if you are using this for reporting, it is recommended that you enable this option for the snapshot. I didn't realize this when I first set up mine, and had to go back and modify my publications.