Support for xml, geospatial datatypes

Oct 19, 2010 at 11:52 AM

There is now 1 audit table. Would it be possible to transform the solution to generate a 'history' table for each table where AutoAudit is used.
Each history table could have the same fields like the source table, so including/supporting fex xml fields. 

A problem I can think of would be : when the structure of a source table would change we would have to drop and recreate the history table.
And by doing this loose the history. But for me the support for geospatial datatypes/xml would be more important than having to reset the history of a table when his structure changes.

Are there other reason I miss why this would not work ?