Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Replication

Author  Topic 

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-03-31 : 05:20:59
Hi,

i have configured replication between two system. but when i add a new stored procedure or modify its not replication to subscriber.
can i have a solution for this

Thanks

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-04-06 : 08:36:05
pls some one tel on this
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-04-06 : 08:41:15
Did you add it to the publication?

http://msdn.microsoft.com/en-us/library/ms173857.aspx
Go to Top of Page

NeilG
Aged Yak Warrior

530 Posts

Posted - 2011-04-06 : 08:43:41
you'll need to add this to you publication otherwise it won't be transferred
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-04-06 : 08:59:21
yes i am adding at publisher but not replicating to subscibr
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-04-06 : 09:37:53
did you look at that article?
did you resynch subscriptions?
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-04-07 : 00:07:54
yes and also i reinitialised all subscription
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-04-07 : 04:27:10
thanks i got it. but how to do autotmatic reinitialisation at subscriber
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-04-07 : 12:00:34
run the snapshot agent
Go to Top of Page
   

- Advertisement -