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

transactional replication Expand / Collapse
Author
Message
Posted Saturday, February 16, 2013 1:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:10 AM
Points: 14, Visits: 171
After configure of transactional replication ,i want to add one more table ?will it be possible ,how will do that?
Post #1420871
Posted Tuesday, May 21, 2013 5:00 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 7:20 PM
Points: 85, Visits: 404
You should be able to add a new table in the publishing database, make sure it is selected in the Publication Properties under the "Articles" page. If you have a test environment setup try it there first.


______________________________
AJ Mendo | @SQLAJ
Post #1454920
Posted Monday, August 19, 2013 6:46 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, December 8, 2014 5:37 AM
Points: 751, Visits: 967
EXEC sp_addarticle
@publication = yourpublication_name,
@article = Table_Name,
@source_object = Table_Name

go through below link, it will help to you .

http://ansqldba.blogspot.in/2012/02/adding-new-article-to-existing.html

Post #1485774
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse