1
Vote

Error with CaptureUser option of sp_StandardCDC_enable_table

description

If passing @CaptureUser = 1 to sp_StandardCDC_enable_table, it fails with an error of invalid column name.
 
The part of the procedure that creates the tracking table creates a column called AuditUser (nvarchar(500) NOT NULL ), but the part of the procedure that created the trigger references a column called AuditName.
 
Standardising the column name to one or the other fixes the problem

comments