"Rich" wrote:

> Hi Karthik,
>
> I have the latest service pack (svcpak4 I believe) which I loaded a couple
> of years ago. Anyway, to run the sp on the publisher what I do is to go to
> QA, use my replication database (not the distribution database - or is that
> where I need to run the sp). Is my replication DB the publisher DB? Or is
> the Distribution DB the publisher?
>
> Thanks,
> Rich
>
> "Karthik" wrote:
>
> > Hi,
> >
> > Ideally add the column using sp_repladdcolumn only at the publisher. Run the
> > snapshot agent at the publisher after that and then try synchronizing.... It
> > should work fine.
> >
> > Avoid adding columns at the subscribers manually.
> >
> > Regards,
> > Karthik
> >
> > "Rich" wrote:
> >
> > > I forgot to mention that I also created the new column, manually, on the
> > > subscriber database, and after replication took place, the new column would
> > > get dropped each time on the subscriber database. What do I need to do so
> > > that the new column does not get dropped?
> > >
> > >
> > > "Rich" wrote:
> > >
> > > > Hello,
> > > >
> > > > I tried adding a column to my test replication DB. Here is what I tried and
> > > > the error message I kept getting:
> > > >
> > > > sp_repladdcolumn 'websubscribers', 'newcol', 'varchar(50)', 'pubwebsubscriber'
> > > >
> > > > >>
> > > > ODBC: Msg 0, Level 19, State 1
> > > > SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005
> > > > EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> > > >
> > > > Connection Broken
> > > > <<
> > > >
> > > > The column did not get added. So I tried adding the column manually through
> > > > EM. I added some data to the column, but it did not replicate - although the
> > > > original columns did still continue to replicate.
> > > >
> > > > Then I tried to drop this new column but got this message - using
> > > > sp_repldropcol...
> > > >
> > > > sp_repldropcolumn 'websubscribers', 'newcol'
> > > >
> > > > >>
> > > > Server: Msg 5074, Level 16, State 1, Line 1
> > > > The object 'DF_WebSubscribers_NewCol' is dependent on column 'newcol'.
> > > > Server: Msg 4922, Level 16, State 1, Line 1
> > > > ALTER TABLE DROP COLUMN newcol failed because one or more objects access
> > > > this column.
> > > > <<
> > > >
> > > > Any assistance greatly apprciated - Note: test replication system is running
> > > > on sql server 2000 personal edition on 2 separate instances of sql server
> > > >
> > > > - will experiment with the real servers - sql server 2000 Standard edition
> > > > - tommorrow morning. I will create some test DBs on the publication server
> > > > and the subscriber server which are on separate machines.
> > > >
> > > > Thanks,