I can’t see changed values with Database Content Audit

SQL Server
6.5 and older
Copy Article URL Copied

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).

Originally KB1811 

Go Up