Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-14 : 16:16:17
|
Tanweer writes "Thanks for creating such an informative site for SQL server, I am using SQL server 2000 on windows 2000 server.I have all the refrential integrity setup on my database. However In some situation I get a some data under conflict table. Yesterday when I review one of my article I found this message
The row was inserted at 'SVR1004SQL.1004_data' but could not be inserted at 'OA-REPLICATE02.1004_data' INSERT statement conflicted with TABLE FOREIGN KEY constraint 'FK_TIMECARD_SPECIAL_BILL_TIMECARD'. The conflict occured in database '1004_data' table TIMECARD.
SVR1004SQL is my publisher
OA-REPLICATE02 is my subscriber (There are no update being done on Subscriber at all).
I have my refrential integrity setup as
TIMECARD child TIMECARD_SPECIAL_BILL
FK_TIMECARD_SPECIAL_BILL_TIMECARD required a TIMECARD before allowing a TIMECARD_SPECIAL_BILL.
When I look at data I see data a PUBLISHER however at subscriber I only see data in TIMECARD table and later data from TIMECARD_SPECIAL_BILL was gone from PUBLISHER alsoe. Someone suggested me to use "NOT FOR REPLICATION" CLasue.
Can you help me on this.
Thanks" |
|
|
|
|
|
Merge Replication Losing Data