I'm working with Sage CRM and MS SQL Server. There are some records that have a Reference ID and then later, a few of those records lose their Reference ID (it gets set to an empty string).

I'd like to figure out when and why this is happening. I was thinking about putting a trigger on the table to try and log when this field goes from a string with length to an empty string.

Has anyone done something like this before?

Thanks!