Issue
Question about what causes table modifications in the ContinuumDB
Environment
CyberStation 1.74 SP2
Windows XP pro SP2
SQL
Cause
Table modifications to the ContinuumDB take place when the database is updated.
Resolution
Table modifications to the ContinuumDB are normal as seen in the DatabaseUpdate.txt file in the Continuum installation directory. (typically c:\program files\continuum)
Tables and other database components can also be modified directly by using SQL Management Studio or Enterprise Manager, but these are unsupported unless specifically directed by Product Support. Direct editing of the database can cause data corruption or unexpected results and cause the database to not function properly. (i.e. 'Error reading database table' or 'Attempt to create duplicate database row')
SQL Profiler can be used to try to target the issue by running SQL profiler at the time the issue occurs and correcting it but if that fails then recreating and rebuilding the db is the only alternative.