Well...
i made a new publication. Queue updatable one.
Now, everything was going ok until a delete statement was thrown.
here is the error
Category:COMMAND
Source: Failed Command
Number:
Message: {CALL sp_MSdel_deportes ('ESN', '', 'Esquí Náutico', 'Water Ski',
1, 1, 1, 1, 1, 1, 0, {D7A8B11C-E1BE-412C-9D12-747A73F63D3A})}
Category:SQLSERVER
Source: PPCUBAN
Number: 547
Message: DELETE statement conflicted with COLUMN REFERENCE constraint
'FK_eventos_deportes'. The conflict occurred in database 'historia', table
'eventos', column 'sigDeporte'.
I can't find what to do to solve this issue and continue replicating. It
just stopped.
Any suggestion?
[quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:O$BwIBwOGHA.1696@TK2MSFTNGP14.phx.gbl...
> Is the publisher online and accessible? If not you will get this error. I
> would use queued or merge over immediate updating unless you know your
> link will always be up.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> 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 >
>
>
> "Jose Fernandez" <ppcuban@hotmail.com> wrote in message
> news:OJKluMlOGHA.1360@TK2MSFTNGP10.phx.gbl...
>> Hello.
>>
>> I have a new issue...
>>
>> I created a publication. It's a Updatable Transaccional Inmediate
>> Updating
>> replication.
>>
>> My C.S.I. is:
>>
>> I have 4 workstation with a localhost web application (subscribers). I
>> have
>> 1 server (Publisher). When I try to enter some data on the subscriber it
>> comes out the error MSDTC on server "XXX" is unavailable (XXX is the name
>> of the subscriber).
>>
>> What should I do about it?
>>
>> Thanks in advance
>>
>>
>>
>>
>
>
