Unfortunately the technique of using SP_REPL_ADDCOLUMN and SP_REPL_DROPCOLUMN with the dummy columns would allow data loss if you didn't take the system down. If you don't take the system down,...
I was thinking to store the end date for historical purposes. In case you found that one of your previous "allergies" was misdiagnosed and no longer relevant, you have access...
The fundamental problem here is a design problem. If you combine each combination of allergies into a new row, it will result in an excessive number of combinations. For example,...
If you perform these through Stored Procedures, then you could modify your stored procedures to perform the logging when an error condition was found. If you were concerned about ad-hoc...