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,...

Itzik Ben-Gan wrote an article that explains this very clearly in SQL Magazine in the October 2004 issue. The InstantDoc ID is #43681.

The problem is that in Old Style Joins,...

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...

Microsoft has released a hotfix that may address this. If you are running Windows Server 2003, try the following hotfix (827452):

http://support.microsoft.com/default.aspx?scid=kb;en-us;827452

Hope this helps,

Jeff