1

Closed

HumanResources.Department left in pAutoAudit

description

I ran pAutoAudit on one of my tables and it returned with:
Msg 208, Level 16, State 1, Procedure pAutoAudit, Line 512
Invalid object name 'HumanResources.Department'.
 
On closer inspection, at line 484 (on mine) of the SP it reads:
  + ' FROM HumanResources.Department' + Char(13) + Char(10)
 
Whereas I think it should read (line below isn't right either):
  + ' FROM ' + @TableName + Char(13) + Char(10)
  + '   WHERE ' + @PKColumnName + ' = @PK )' + Char(13) + Char(10) + Char(13) + Char(10)
 
I've changed it on my version, but it's just for your distribution version ;o)
 
Pol
Closed Apr 8, 2010 at 4:56 PM by PaulNielsenSQL
fixe a long time ago.

comments

Pol wrote Feb 3, 2009 at 2:14 PM

being pedantic now, but there is also a typo in your comments:

2) adds created and modified columns to table
3) builds insert, update, and modified audit trail trigger

AutoAditDrop 'schema', 'table'
------^