Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to SQL Server Replication: STEP 3 - Transactional Replication – The Publisher Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 10:37 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 9, 2011 7:01 AM
Points: 15, Visits: 36
Comments posted to this topic are about the item Stairway to SQL Server Replication: STEP 3 - Transactional Replication – The Publisher
Post #1063696
Posted Wednesday, November 20, 2013 8:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 7, 2014 10:32 AM
Points: 195, Visits: 362
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.
Post #1516092
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse