Re: cannot deliver sp_repldropcolum schema change

My guess is that something references the column on the subscriber. Please
take a look at this article and see if it applies:
http://support.microsoft.com/kb/816755
One way to test this would be to restore a backup of the subscriber database
to another database nema and try to drop the column directly and hopefully
you wont be able to and will get a message referring to the constraint that
prevents the drop. If you can get this, you can drop the constraint using
sp_addscriptexec (assuming it is nothing to do with a filter).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .


.

Relevant Pages

  • Re: SQL 2005 and Replication
    ... fulltext function such as CONTAINSor FREETEXT? ... can you check the history of snapshot agent? ... decision for enabling fulltext index in the subscriber database. ...
    (microsoft.public.sqlserver.replication)
  • Re: Workarround in identities in Merge Replication to avoid the use of auto identity range
    ... A not for replication check constraint would probably be ideal. ... to another Subscriber and forget to change this code.... ... I've found that automatic range management could be ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL 2005 and Replication
    ... fulltext function such as CONTAINSor FREETEXT? ... can you check the history of snapshot agent? ... decision for enabling fulltext index in the subscriber database. ...
    (microsoft.public.sqlserver.replication)
  • Re: Generics and delegates
    ... If the delegates that you are going to handle always follow the standard pattern, then you could make the constraint on EventArgs, and assume that the parameter list will adhere to the standard event pattern. ... /// when the subscriber wants to subscribe via a weak reference ... subscriberMethod, EventInfo provider): base ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL 2005 Merge Replication - Drops identity range constraint after insert.
    ... new table with a primary key (with NOT FOR REPLICATION set) to the ... The table is created on the subscriber and the constraint ... and the publisher table..and the primary key is set as identity ...
    (microsoft.public.sqlserver.replication)
Loading