Page History
...
Stores snapshots of the database properties. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
Column Name | Column Description |
---|---|
SQCD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCD_DATABASE_ID | Internal ID of the database. |
SQCD_DATABASE_NAME | Name of the database in which the change occurred. |
SQCD_RECOVERY | Recovery model of the database. |
SQCD_AUTO_UPDATE_STATISTICS | Auto-update statistics status of the database. |
SQCD_ANSI_NULL | Ansi null status of the database. |
SQCD_AUTO_SHRINK_FILES | Autoshrink files status of the database. |
SQCD_CLOSE_CURSORS_ON_COMMIT | Close cursor on commit status of the database. |
SQCD_STATUS | Availability status of the database. |
SQCD_AUTOCREATES_STATISTICS | Autocreate statistics status of the database. |
SQCD_TRUNCATES_LOG | Truncate log status of the database. |
SQCD_COMPATIBILITY_LEVEL | Compatibility level of the database. |
SQCD_OBJECT_SAMPLE_STATUS | Status of tracking changes on objects in the database. |
SQCD_COLUMN_SAMPLE_STATUS | Status of tracking changes on columns in the database. |
SQCD_INDEX_SAMPLE_STATUS | Status of tracking changes on indexes in the database. |
SQCD_INDEX_K_SAMPLE_STATUS | Status of tracking changes on keys in the database. |
SQCD_DATABASES_SAMPLE_STATUS | Status of tracking changes on database definitions in the database. |
SQCD_PS_SAMPLE_STATUS | To support partition schema collecting. |
SQCD_PS_FG_SAMPLE_STATUS | To support file group collecting pointed by partition schema. |
SQCD_PF_SAMPLE_STATUS | To support partition function collecting. |
SQCD_PF_VALUES_SAMPLE_ |
...
STATUS | To support partition function values collecting of a particular partition function. |
SQCD_AUTO_UPDATE_STATS | Database option. |
SQCD_PARAMS_FORCED | Database option. |
SQCD_DATE_CORRELATION | Database option. |