Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete old replication procedure (system stored procedures)

Status
Not open for further replies.

Corran007

Programmer
May 20, 2002
530
US
I have a fair amount of old replication stored procedures on some of my subscribers. They were from previous replication issues back from when i was still learning.

What is the best way to get rid of them. I remember there is a command to swap stored procedurecs between system and regular and then i could just delete but i was wondering if anyone knew of a better way.+-
 
May want to take a look at this post from a while back. May give you some good info.

thread962-778056


Thanks

J. Kusch
 
I had seen that one, but mine is a bit differnent. My replication works fine. Its just that my subscribers still have the old non needed stored procedures that are create for mergereplication. Im also wondering if somewhere on the subscribers it isnt still in there somewhere, but where i dont know.
 
I'm always afraid to delete old stuff, so when I decide to...I take a baby step. Change the name to DELETEspWhatEver. If nothing breaks in the next few hours/days/weeks/etc, then I finish the job.
-Karl
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top