sql server replication: Hi,

There is an argument "schema_change_script" in sp_repladdcolumn.
I didn't find how it works in SQL BOL. Can someone explain it to me a bit
more?

Thanks

Darius

This is the path of a SQL script used to modify the system generated custom
stored procedures. Replication allows user-defined custom stored procedures
to replace one or more of the default procedures used in transactional
replication. schema_change_script is executed after a schema change is made
to a replicated table article using sp_repladdcolumn, and can be used to do
one of the following:
a.. If custom stored procedures are automatically regenerated,
schema_change_script can be used to drop these custom stored procedures and
replace them with user-defined custom stored procedures that supports the
new schema.
b.. If custom stored procedures are not automatically regenerated,
schema_change_script can be used to regenerate these stored procedures or to
create user-defined custom stored procedures.
The default values is NULL

HTH - Deepak
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]