Re: Field msrepl_tran_version added

There are default contraints on that field. You'll have to drop those
constraints bfore dropping the column itself. you should do a select on
sysobjects to find the default constraints like '%df_%_msrepl%'. i would
assume, replication is not in place(immediate updating or queued updating).
Once you drop the constraint, it lets u drop the column.

HTH

Tejas

"Roy Goldhammer" wrote:

> Whell Hilary:
>
> When i tried to delete the field by this code?
>
> ALTER TABLE Client
> DROP COLUMN msrepl_tran_version
>
> I got an error:
> Server: Msg 5074, Level 16, State 1, Line 1
> The object 'DF__Client__msrepl_t__02FED618' is dependent on column
> 'msrepl_tran_version'.
> Server: Msg 4922, Level 16, State 1, Line 1
> ALTER TABLE DROP COLUMN msrepl_tran_version failed because one or more
> objects access this column.
>
> how can i delete these records?
>
> "Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
> news:%23y6ZYGMAGHA.2656@xxxxxxxxxxxxxxxxxxxxxxx
> > You have to run a script to drop them. These columns are using by
> > immediate updating or queued updating publications. Have you need of these
> > publications?
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> >
> > "Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
> > news:%23EzlsbLAGHA.3296@xxxxxxxxxxxxxxxxxxxxxxx
> >> Hello there
> >>
> >> I've create transacional replication from two databases. At the publisher
> >> new field added to all the tables i mark as replicated:
> >> msrepl_tran_version
> >>
> >> It cause damage to my database. What i need to do to ged rid of them? and
> >> what i need to do so they won't be created again?
> >>
> >> --
> >> øåòé âåìãäîø
> >> òúéã äðãñú úåëðä
> >> èì' 03-5611606
> >> ôìà' 050-7709399
> >> àéîééì: roy@xxxxxxxxxxxx
> >>
> >
> >
>
>
>
.

Relevant Pages

  • Re: Adding a nosync article to an existing transactional publication
    ... Queued updating is not scalable where a large ... portion of the DML originates at the Subscriber. ... Looking for a SQL Server replication book? ... online, accepting transactions. ...
    (microsoft.public.sqlserver.replication)
  • Re: Check constraints not being replicated properly
    ... I DO want to enforce the constraints at the ... DML during replication because of the partitioned view requirements. ... We have a date_created partitioning ... How can I make sure the snapshot does not create the tables on the ...
    (microsoft.public.sqlserver.replication)
  • Re: id manage problem with ID RANGES in merge.
    ... range at the sub was 700001-1400000. ... There is a bug when you drop the subscription the replication check ... You might not be able to delete the check constraints but you should be able ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Check constraints not being replicated properly
    ... Do you want this constraint enforced on the subscriber when the DML is ... occurring due to a replication process? ... Please post your schema of the table with the constraints and I'll show you ... We have a date_created partitioning column in ...
    (microsoft.public.sqlserver.replication)
  • Re: REAL REAL Experts needed for pretending to be replication_agent
    ... Looking for a SQL Server replication book? ... "Nury SWORD" wrote in message ... but I am facing CONSTRAINTS that merge ... > agent does not face. ...
    (microsoft.public.sqlserver.replication)