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.
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 thisThanks |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2011-04-06 : 08:36:05
|
pls some one tel on this |
 |
|
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 |
 |
|
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 |
 |
|
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 |
 |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-04-06 : 09:37:53
|
did you look at that article?did you resynch subscriptions? |
 |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2011-04-07 : 00:07:54
|
yes and also i reinitialised all subscription |
 |
|
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 |
 |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-04-07 : 12:00:34
|
run the snapshot agent |
 |
|
|
|
|