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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  SQL Transactional Replication (Urgent)

Author  Topic  diggers Starting Member 8 Posts Posted - 2002-10-30 : 04:32:16 Hi, I am setting up Transactional Replication on SQL server and have run into a problem. If I am only using a stattic table I have no probelm but when I use a table with some constraints it fails and I get the error below? Anyone explain where I am going wrong? Thanks Last command: delete from "ADMISSIONS" where "ADMISSIONDBOID" = 4222198370415002108 Transaction sequence number and command ID of last execution batch are 0x0000000900000FAF005900000000 and 15. Error; DELETE statement conflicted with COLUMN REFERENCE constraint 'ADMISSIONAMBULATSTATUS_FK2'. The conflict occurred in database 'CS63VISN21', table 'ADMISSIONAMBULATORYSTATUS', column 'ADMISSIONDBOID'. (Source: GTS-MAYO\PICIS (Data source); Error number: 547)