change article definition for stored proc
From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 03/01/05
- Next message: Kestutis Adomavicius: "Re: Failed to enumerate changes in the filtered articles."
- Previous message: Hassan: "what is @force_invalidate_snapshot"
- In reply to: Hassan: "change article definition for stored proc"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Mar 2005 01:07:08 -0800
You could use sp_dropsubscription, sp_droparticle,
sp_addarticle with @type = 'proc exec',
sp_addsubscription and then run the snapshot agent and
synchronize.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
- Next message: Kestutis Adomavicius: "Re: Failed to enumerate changes in the filtered articles."
- Previous message: Hassan: "what is @force_invalidate_snapshot"
- In reply to: Hassan: "change article definition for stored proc"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
