November 30, 2007 at 2:40 am
Is there any way that new objects will get created in the subscriber database which has been created at the publisher's end, like a new stored procedure, after the replication has been setup?
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
November 30, 2007 at 2:58 am
In transactional and Merg replication it is possible
November 30, 2007 at 3:56 am
But how?
I would like to use the transactional replication.
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
November 30, 2007 at 1:19 pm
After the objects are created on the publisher you need to use sp_addarticle an run the snapshot agent.
the distributor will pick those up an apply them.
* Noel
December 1, 2007 at 10:44 pm
Define ur new objects(table,sp,view..) using sp_addarticle then define ur subscriber using sp_addsubscription. Run it in publisher side.
Then start your snapshot agent. Now your new article will be availble in your subscriber.
Thanks,
Balaji L
December 2, 2007 at 11:37 pm
Great...........thanks!
That was quite a good help from you.
🙂
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply