Scott - do you have anything in sysmergeschemachange at all? Has anyone run
sp_markpendingschemachange?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

HI!

Sometimes with my testing pubs/subs schema (ddl) changes does not happen,
even though it's set to true in the pub:

compatibility is 90, etc...

example:

alter table [intra_events] alter column [eventDesc] varchar(600)

this changes the pub db, but it does not propagate, also i check:

exec sp_enumeratependingschemachanges 'PUB1_IntranetGB'

and nothing is q'd up...

anyone else run into this?

I need to test schema changes in test db's before I apply them to production
servers--

no there are no entries at all -- it is strange, i do not know where its
coming from--

[quoted text, click to view]

no, no one has run sp_markpendingschemachange

[quoted text, click to view]

interesting... I had some tables set as download only to the subscriber.. i
removed all those, so all tables were bi-directional

(the table i was trying to alter was bidirectional already --)

i re-inited, and ddl schema chgs then propagated



then as another test i just set one table to download only, reinited --

ddl schema chges still worked...

so one of my table set to download only must be blocking ddl chgs somehow

i'll do some more test to see if i can isolate the problem--


[quoted text, click to view]