Adam, thank you for the explanation.  The issue is understandable (we deal with the same through our own web service API).  Wasn't sure if you noticed or not, but I did post a trigger in the thread referenced above that resolves the issue:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

ALTER TRIGGER [DefectInsert]

ON [dbo].[Defects]

FOR INSERT

AS

SET NOCOUNT ON;

DECLARE @newdefectid int

select @newdefectid = DefectID FROM inserted

UPDATE Defects SET

ReplicationProcedures = REPLACE(SUBSTRING(ReplicationProcedures, 1, DATALENGTH(ReplicationProcedures)), CHAR(10), CHAR(13) + CHAR(10)),

Description = REPLACE(SUBSTRING(Description, 1, DATALENGTH(Description)), CHAR(10), CHAR(13) + CHAR(10)),

Notes = REPLACE(SUBSTRING(Notes, 1, DATALENGTH(Notes)), CHAR(10), CHAR(13) + CHAR(10))

WHERE DefectID = @newdefectid