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 |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2008-02-28 : 12:05:49
|
| Hello Replication Gurus,Is it a good practice to run output script from sp_scriptpublicationcustomprocs on publisher? so that with every restore, subscribers will have those stored procedures and don't need to run script everytime you recreate replication.I am just trying to avoid one step everytime I recreate replication.Any positive/negative points in doing this?TIA---------------------------Sandesh - The Messenger |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-28 : 12:20:32
|
| Try this:http://support.microsoft.com/kb/320499/EN-US/ |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-02-28 : 13:27:18
|
| I know...but i want to avoid running those stored procedures' output on subscribers.I wanted to ask is it a good (Best) practice to run the script on Publisher itself so that it will be populated on subscribers via restore...so don't need to run script each time on each subscriber.---------------------------Sandesh - The Messenger |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 22:48:12
|
| Don't think it's good practice, otherwise Microsoft will ask you do so. |
|
|
|
|
|
|
sp_scriptpublicationcustomprocs