Merge Replication - Custom Stored Procedures

[nicsin]

Hi all,

I 've got an sql server which uses merge replication with client laptops for synchroinisation of data. It is working ok but I was wondering if there is a way to replicate stored procedures.

I am using the system stored procedure sp_addmergearticle for tables and views but still haven't found a way to replicate custom stored procedures.

Thanks for you help

 

[mrdenny]

According to BOL Stored Procedures - Definition can be replicated via Merge, Snapshot and Transaction Replication.

You should be able to add them as articles.

The type should be "proc schema only".

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[nicsin]

Excellent. Thanx a lot!

Sorry about the late reply