Error message:String or binary data would be truncated.Statement has been terminated. This error message means that you are trying to enter a string into a column that is not wide enough to store that string. For example, if you had a column that is defined as VARCHAR(5) and you tried to enter a six-character (or longer) string - e.g. "ABCDEF" into that column, you will get this error message.
Insert statement conficted with FK constraint in database "OLTP" table Property_source column 'Property_ID This message is telling you that there is no row in the PROPERTY table that matches the Property_ID value that you are trying to enter into LOAN table. The foreign key constraint that you set up means that for every row that you want to enter into the LOAN table, the Property_ID value you will be inserting has to be in the PROPERTY table.