Step 1 :- Add Artical
USE [Publication DB NAME]
GO
EXEC sp_addarticle
@publication = '[Publication Name]',
@article = N'[ARTICAL NAME]',
@source_object = N'[ARTICALNAME]',
@force_invalidate_snapshot=1
GO
Step 2:-
EXEC sp_changepublication
@publication = '[publication name]',
@property = N'allow_anonymous',
@value = 'false'
GO
EXEC sp_changepublication
@publication = '[publication name]',
@property = N'immediate_sync',
@value = 'false'
GO
Step 3:- Run the snapshot agent either from replication monitor or from agent.
Step 4: Make Flags true used in Step 2
More Help on :- http://support.microsoft.com/kb/830210
http://dba.stackexchange.com/questions/12725/add-article-to-transactional-publication-without-generating-new-snapshot
USE [Publication DB NAME]
GO
EXEC sp_addarticle
@publication = '[Publication Name]',
@article = N'[ARTICAL NAME]',
@source_object = N'[ARTICALNAME]',
@force_invalidate_snapshot=1
GO
Step 2:-
EXEC sp_changepublication
@publication = '[publication name]',
@property = N'allow_anonymous',
@value = 'false'
GO
EXEC sp_changepublication
@publication = '[publication name]',
@property = N'immediate_sync',
@value = 'false'
GO
Step 3:- Run the snapshot agent either from replication monitor or from agent.
Step 4: Make Flags true used in Step 2
More Help on :- http://support.microsoft.com/kb/830210
http://dba.stackexchange.com/questions/12725/add-article-to-transactional-publication-without-generating-new-snapshot
No comments:
Post a Comment