This tab allows for checking of certain objects while excluding certain categories like Primary Key and BLOB fields like Image and Text that aren't normally audited.

For example, you selected the boxes as it’s shown at the screenshot above. Now you can check all fields except Primary and Designated Key, Text and Ntext fields at once. Click at the top checkbox:

You can see now that the primary key fields and Ntext field were not checked:

Also, these column types cannot be checked manually if you select the "Validate to Prevent Manually Checking of These Columns" option.
Here is the results of the selected check-boxes in the figure above:

|
Field |
Description |
|
Primary Key |
The fields of the table's primary key. |
|
|
|
|
Designated Key |
The fields of the custom key defined by the user in Row Key dialog. |
|
|
|
|
Image Fields |
These are fields of image type. |
|
|
|
|
Text/NText Fields |
These are fields of text or ntext type. |
|
|
|
For information about any button in the Options dialog click here.
Copyright © 2008 ApexSQL LLC. All Rights Reserved.