"Brad M." <anonymous@discussions.microsoft.com> wrote in message
news:eqERgVznDHA.2732@TK2MSFTNGP11.phx.gbl...
> USE JCS
>
> EXEC master.dbo.sp_repldropcolumn 'Timesheets', 'RegularKM'
>
> When I execute the above command on my publisher, I get the following
error.
> How can I fix this? I have to remove this column as well as another one,
> and add four more. Any help will be much appreciated!!!!
>
> Below is error.....
>
> Warning: only Subscribers running SQL Server 2000 can synchronize with
> publication 'JCS' because schema replication is performed.
>
> Server: Msg 5074, Level 16, State 1, Line 1
>
> The object 'DF_Timesheets_RegularKM' is dependent on column 'RegularKM'.
>
> Server: Msg 4922, Level 16, State 1, Line 1
>
> ALTER TABLE DROP COLUMN RegularKM failed because one or more objects
access
> this column.
>
>
>
> Best Regards,
>
> Brad
>
>

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:%23cA$gh0nDHA.2424@TK2MSFTNGP10.phx.gbl...
> you are using it correctly, but I think you should drop the constraint
> before doing this. Use sp_addscriptexec on your publisher to drop this
> constraint on all of your subscribers.
> "Brad M." <anonymous@discussions.microsoft.com> wrote in message
> news:eqERgVznDHA.2732@TK2MSFTNGP11.phx.gbl...
> > USE JCS
> >
> > EXEC master.dbo.sp_repldropcolumn 'Timesheets', 'RegularKM'
> >
> > When I execute the above command on my publisher, I get the following
> error.
> > How can I fix this? I have to remove this column as well as another
one,
> > and add four more. Any help will be much appreciated!!!!
> >
> > Below is error.....
> >
> > Warning: only Subscribers running SQL Server 2000 can synchronize with
> > publication 'JCS' because schema replication is performed.
> >
> > Server: Msg 5074, Level 16, State 1, Line 1
> >
> > The object 'DF_Timesheets_RegularKM' is dependent on column 'RegularKM'.
> >
> > Server: Msg 4922, Level 16, State 1, Line 1
> >
> > ALTER TABLE DROP COLUMN RegularKM failed because one or more objects
> access
> > this column.
> >
> >
> >
> > Best Regards,
> >
> > Brad
> >
> >
>
>

"Brad M." <anonymous@discussions.microsoft.com> wrote in message
news:upaeZs8nDHA.1960@TK2MSFTNGP12.phx.gbl...
> Hi Hilary,
>
> I'm not sure how to do this, so could you give me some example syntax to
> implement this?
>
> Thanks!
> Brad
>
> "Hilary Cotter" <hilaryk@att.net> wrote in message
> news:%23cA$gh0nDHA.2424@TK2MSFTNGP10.phx.gbl...
> > you are using it correctly, but I think you should drop the constraint
> > before doing this. Use sp_addscriptexec on your publisher to drop this
> > constraint on all of your subscribers.
> > "Brad M." <anonymous@discussions.microsoft.com> wrote in message
> > news:eqERgVznDHA.2732@TK2MSFTNGP11.phx.gbl...
> > > USE JCS
> > >
> > > EXEC master.dbo.sp_repldropcolumn 'Timesheets', 'RegularKM'
> > >
> > > When I execute the above command on my publisher, I get the following
> > error.
> > > How can I fix this? I have to remove this column as well as another
> one,
> > > and add four more. Any help will be much appreciated!!!!
> > >
> > > Below is error.....
> > >
> > > Warning: only Subscribers running SQL Server 2000 can synchronize with
> > > publication 'JCS' because schema replication is performed.
> > >
> > > Server: Msg 5074, Level 16, State 1, Line 1
> > >
> > > The object 'DF_Timesheets_RegularKM' is dependent on column
'RegularKM'.
> > >
> > > Server: Msg 4922, Level 16, State 1, Line 1
> > >
> > > ALTER TABLE DROP COLUMN RegularKM failed because one or more objects
> > access
> > > this column.
> > >
> > >
> > >
> > > Best Regards,
> > >
> > > Brad
> > >
> > >
> >
> >
>
>