This project is read-only.

'SchemaAuditDDLTrigger' causing index rebuild error

Executing the query "ALTER INDEX [PK_AuditSettings] ON [Audit].[AuditSe..." failed with the following error: "The definition of object 'SchemaAuditDDLTrigger' has changed since it was compiled. The...

Id #43426 | Release: None | Updated: May 26, 2016 at 10:42 AM by tonyfosterit | Created: May 26, 2016 at 10:42 AM by tonyfosterit

getdate() bug in archiving procedures

The condition clauses inside pAutoAuditArchive procedure is incorrect. Consider: WHERE AuditDate < DATEADD(day, @DeleteAfterNumberOfDays * -1, getdate()) It is repeated in multiple statements, fir...

Id #43323 | Release: None | Updated: Jan 11, 2016 at 9:43 AM by azarubkin | Created: Jan 11, 2016 at 9:43 AM by azarubkin

Issue with column orders in pAutoAudit

First of all I would like to thank you for the amazing job you've done with this script! It is reale awesome! I would like to share same issues thouhh. I had experienced errors in genereting objec...

Id #43306 | Release: None | Updated: Dec 2, 2015 at 6:26 PM by radekceluch | Created: Dec 2, 2015 at 6:26 PM by radekceluch

Restoring the identity value after trigger runs

When I insert a record in the table that is audited and has Identity column, it is impossible to retrieve the inserted value back, because @@IDENTITY in Microsoft SQL Server returns the last insert...

Id #43302 | Release: None | Updated: Nov 26, 2015 at 9:37 AM by azarubkin | Created: Nov 26, 2015 at 9:37 AM by azarubkin

Add TransactionId to AuditHeader

It is important for us to be able to group AuditHeader records by the database transaction id that generated them. Would that be possible to add? I am considering forking and adding this myself but...

Id #43295 | Release: AutoAudit 3.30a | Updated: Nov 27 at 5:54 PM by JohnSigouin | Created: Nov 17, 2015 at 6:49 PM by pwhe23

Bug - UDF RowHistory does not return correct data

Hi, Firstly, I just want to say what a great tool this is. I think I have found a bug. I'll try to be as clear and succinct as possible. The issue lies in the UDF RowHistory. I ran some tests...

Id #43282 | Release: None | Updated: Nov 3, 2015 at 3:45 AM by discens | Created: Nov 3, 2015 at 1:06 AM by discens

_TableRecovery issue?

Hello John, nice work with this tool. I have started to use it in our company, we have an "employee" table and as per autoaudit documentation about _TableRecovery UDF: _ "This UDF takes a date/t...

Id #43281 | Release: None | Updated: Nov 2, 2015 at 10:00 PM by ccasaverde | Created: Nov 2, 2015 at 10:00 PM by ccasaverde

slow performance issues

Hi anyone experience slow performance issues on autoaudit 3.30 ? i facing slow performance issues and causing whole system time out on production server. please advise any solution to it . Thanks,

Id #43241 | Release: None | Updated: Jun 3 at 9:59 AM by ChrisDre | Created: Sep 14, 2015 at 11:23 AM by jonathan1234566

Always Log a non-primary column

Hi Paul and John, I would like to log a non-primary column value in AuditDetails table regardless whether it's been changed. Is there away to do so? Thanks, Sam

Id #43103 | Release: None | Updated: Nov 27 at 5:54 PM by JohnSigouin | Created: Apr 30, 2015 at 4:44 AM by imatrix

Unable to modify table. Cannot find the object...

When using the Designer to modify a table, and to insert columns other than on the end of the table, I get this error when clicking Save (or exiting out of) the Table Designer: 'Employee' table ...

Id #35828 | Release: None | Updated: May 4, 2016 at 9:41 PM by Runamok81 | Created: Feb 4, 2015 at 10:00 PM by NealWalters