sql server replication: Lee,
have a look at this:
http://www.replicationanswers.com/AddColumn.htm
It refers to tables, but would equally apply to stored
procedures.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

What is the best solution for maintaining a database that is used for
replication? I now how to implement table changes such as adding new
tables or adding and dropping columns. I am more interested in how to
maintain replicated stored procedures. I get the following error when
trying to drop and re-create a storted procedure that is replicated.

Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the procedure 'procedureName' because it is being used for
replication.

Does anyone have any thoughts or know where to point me?

Thanks.

--Lee

--