Re: Field msrepl_tran_version added

You will have to drop the constraints before dropping the column.

--
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:%23ePeTNMAGHA.3864@xxxxxxxxxxxxxxxxxxxxxxx
> 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
Loading