Re: Field msrepl_tran_version added

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: Field msrepl_tran_version added
    ... These columns are using by immediate ... updating or queued updating publications. ... Looking for a SQL Server replication book? ... > I've create transacional replication from two databases. ...
    (microsoft.public.sqlserver.replication)
  • Re: Major Latency problems
    ... replication monitor is because they are occasionally wrong. ... represent cumulative values since the last time the distribution agent ... Replication monitor latency is 1 ... you're asking me to alter a stock replication system table. ...
    (microsoft.public.sqlserver.replication)
  • RE: can not remove rowguid currently replicated
    ... ALTER TABLE DROP COLUMN failed because 'rowguid' is currently replicated. ... -- Unmark table for replication ... ALTER TABLE ErrorLog ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_repladdcolumn for Indexed Views
    ... If you alter the view it will ... and alter the Insert and Update procs on the Sub. ... >> Replication that Im going to be replicating column test. ...
    (microsoft.public.sqlserver.replication)
  • Re: Major Latency problems
    ... you're asking me to alter a stock replication system table. ... Why is the latency figure in replication monitor not useful? ... > This will tell you the current latency on your subscriber. ...
    (microsoft.public.sqlserver.replication)