Is it possible to replicate Store Procedure ?

[Kail]

Is it possible to replicate Store Procedure ?

Because I cannot found the article for is, does anyone try it before?

--

[Paul Ibison]

Kail,
stored procedures can be replicated as any other article.
The things to remember are that we can't replicate system
tables, so the text of the stored proc (syscomments)
won't be replicated in the same way as normal user data.
This means that if the procedure changes, it won't be
picked up by the replication process. As they are treated
in a different way, and a new snapshot might be needed on
a regular basis, you might want to place the stored procs
in a separate publication. This is how I set things up,
with a post-snapshot script to be run which adds the
permissions.
Another aspect of replicating stored procedures is that
transactional replication will give you the option to
replicate the EXECUTION of the stored procedure as well
as the procedure itself.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

[Kail]

Dear Paul

Thanks for your help

kail
--

Post by Paul Ibison
Kail,
stored procedures can be replicated as any other article.
The things to remember are that we can't replicate system
tables, so the text of the stored proc (syscomments)
won't be replicated in the same way as normal user data.
This means that if the procedure changes, it won't be
picked up by the replication process. As they are treated
in a different way, and a new snapshot might be needed on
a regular basis, you might want to place the stored procs
in a separate publication. This is how I set things up,
with a post-snapshot script to be run which adds the
permissions.
Another aspect of replicating stored procedures is that
transactional replication will give you the option to
replicate the EXECUTION of the stored procedure as well
as the procedure itself.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
http://www.nwsu.com/0974973602p.html)

[nelson david]

hello im nelson david her in saudi arabia i like to order ur unit,submariner 18k ss watch code.rx405 in the price of 115 dallor onl

From http://www.developmentnow.com/g/114_2004_10_0_0_446462/Is-it-possible-to-replicate-Store-Procedure-.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/