Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

ADD TRANDATA <table name> will add the supplemental logging to all columns of table if the table does not have either primary key or a unique key. Once we applied the ADD TRANDATA how do we revert it and apply the supplemental logging to a specific column. If I issue the below command, will it remove the existing supplemental logging with all column and to be specific to the list of column list?

ADD TRANDATA <table name>, COLS (list of column names), NOKEY
share|improve this question

migrated from serverfault.com Dec 3 '12 at 2:27

This question came from our site for professional system and network administrators.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.