During the creation or reinit of a subscription, the tables involved in the
publication are schema locked.

Where can I find information about why this is needed and details of what a
schema lock is. The BOL are very vague in this area.

Thanks

basically the replinfo table is changed from a value of 0
in sysobjects, and in syscolumns the value of colstat is
or'd with 4096.

Be extremely careful about making modifications to these
values. In fact I would strongly recommend only making
changes to them with PSS holding your hand.

The schema is locked to prevent replication from failing.
With the schema locked, replication will now what columns
and data types to expect on the subscibers and publishers.

[quoted text, click to view]