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.

add comment

Your Answer

 
discard

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