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)
 replication database

Author  Topic 

alfred1967
Starting Member

2 Posts

Posted - 2009-09-22 : 11:53:28
I can't insert record into the replication database, and it gaves the below error message.....

"The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.
The statement has been terminated."

The database was replicated from another server, and it is a dbo owned database.

Please kindly enlighten, and thanks in advance for assistance.

alfred1967
Starting Member

2 Posts

Posted - 2009-09-22 : 11:57:02
By the way, I didn't add any 'WITH CHECK OPTION' while doing the replication.........and this error really make me mad.......
Go to Top of Page
   

- Advertisement -