SQL Server Foreign Key- Sql Server Error Msg 547. The DELETE statement conflicted with the REFERENCE constraint.
This error occurs when no action is defined for “ON DELETE” and the DBA tries to delete from parent table.
For complete and quick analysis with example, go through following link – http://mssqlcorruptiontackle.blogspot.com/2010/12/sql-server-2008-r2-foreign-key-delete.html
The above link can also help you in determining following error:
SQL Server Foreign Key- Sql Server Error Msg 547. The INSERT statement conflicted with the FOREIGN KEY constraint.
INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- Powershell Interview Questions and Answers
Online SQL Classes @ http://tuitionaffordable.webstarts.com