1

Resolved

pAuditDrop and pAuditDropAll fails

description

When attempting to run pAutoAuditdrop or pAutoAuditDropAll it fails as the columns it is trying to remove has constraints that was created when either pAutoAudit and pAutoAuditAll is run.
 
Example:
Msg 5074, Level 16, State 1, Line 1
The object 'Users_Created_df' is dependent on column 'Created'.
Msg 4922, Level 16, State 9, Line 1
ALTER TABLE DROP COLUMN Created failed because one or more objects access this column.

comments

PaulNielsenSQL wrote Oct 14, 2008 at 12:21 AM

I think this is fixed, if you see the issue again please re-open this issue. -Paul