Send Knowledge Base Article
The article has been sent to your inbox successfully.
We never share your data
I can't see changed values with Database Content Audit
KB1811 | Last review: Jan 06, 2014 | Netwrix Auditor for SQL Server | All
|If you have enabled database content audit and receive a report which contains only the number of modified rows without values, it means that target table does not contain a primary key. To add a primary key to the table please run the following SQL Command:
ALTER TABLE target_table_name
ADD PRIMARY KEY (primary_key_column_name)
please note that If you use the ALTER TABLE statement to add a primary key, the primary key column must already have been declared to not contain NULL values (when the table was first created).
Was this information helpful?