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

wrote Oct 14, 2008 at 12:21 AM

wrote Feb 14, 2013 at 7:21 PM

wrote May 16, 2013 at 9:24 AM

wrote May 16, 2013 at 9:24 AM

wrote Jun 14, 2013 at 7:12 AM