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

SQL SERVER 2008 R2 ISSUE IN TRANSACTIONAL REPLICATION Expand / Collapse
Author
Message
Posted Monday, February 17, 2014 7:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 40, Visits: 353

FROM FRONT END WE ARE USING AXAPTA FROM THERE TWO COLUMN ADDED IN A TABLE ITS ALREADY DATABASE IN TRANSACTIONAL REPLICATION. AFTER ADDED REPLICATION FAILED .WE ARE REINATILZE ALL SUSCRIPTION .THAT TIME SERVER IS HANG AND LOST THE CONNECTION .REPLICATION STATUS SHOWING CRITICAL IN SQL SERVER 2008 R2 .SO WE REMOVE THE REPLICATION AND CREATE NEW PUBLISHER AND SUBRIBER FOR 10 TABLES ITS WORKING FINE NOW

MY QUESTION IS
=============
1.WHAT WE HAVE TO DO BEFORE ADDING NEW COLUMN IN TRANSACTIONAL REPLICATION TABLES
2.ONCE COLUMN ADDED HOW TO REINTAILZE FOR PARTICULAR TABLES
3.HOW TO CHECK FROM FRONT END ANY COULMN ADDED IN TABLES ITS IN REPLICATION

PLEAS HELP ME
Post #1542110
Posted Monday, February 17, 2014 10:15 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Pl. refer following link for details:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6d46e537-f9d8-4b42-aacb-817550393b92/adding-columns-to-article-in-transactional-replication-without-reinit?forum=sqlreplication

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1542362
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse