1
Vote

Typo in SchemaAuditDDLTrigger

There is an issue with database trigger SchemaAuditDDLTrigger "StrictUserContext = 1" should be replaced by "StrictUserContext :1" The same for StrictUserContext :0 "StrictUserContext = 0" should...

Id #32338 | Release: None | Updated: Mar 1 at 4:54 PM by rosacek | Created: Mar 1 at 4:54 PM by rosacek

1
Vote

Typo in SchemaAuditDDLTrigger

There is an issue with database trigger SchemaAuditDDLTrigger "StrictUserContext = 1" should be replaced by "StrictUserContext :1" The same for StrictUserContext :0 "StrictUserContext = 0" should...

Id #32337 | Release: None | Updated: Mar 1 at 4:54 PM by rosacek | Created: Mar 1 at 4:54 PM by rosacek

1
Vote

RowVersion initial Null - missing Coalesce

Version 2.00h, proc dbo.pAutoAudit If there are records before audit is set on the table, RowVersion column is Null and original formula without Coalesce theefore doesn't work --- [RowVersion] = ['...

Id #32194 | Release: None | Updated: Feb 7 at 4:42 AM by rosacek | Created: Feb 7 at 4:42 AM by rosacek

1
Vote

Too many table names in the query

Hi Paul, First off great tool. I am running in to one small snag. I have a table with 191 columns and I'm receiving the following error when I attempt to run pAutoAuditdrop dbo,products. Msg 106...

Id #30765 | Release: None | Updated: May 27 2011 at 4:01 PM by jdshrop87 | Created: May 27 2011 at 4:01 PM by jdshrop87

1
Vote

Problem when a null is inserted

Hi, First of all, I love the AutoAudit, thanks for the scripts. I've seen a problem when I inserted a NULL value for a column named COL1 in my TEST table. If I update that COL1 to value1 and t...

Id #30697 | Release: None | Updated: May 14 2011 at 7:05 PM by cjt | Created: May 14 2011 at 7:03 PM by cjt

1
Vote

Problem when a null is inserted

Hi, First of all, I love the AutoAudit, thanks for the scripts. I've seen a problem when I inserted a NULL value for a column named COL1 in my TEST table. If I update that COL1 to value1 and t...

Id #30696 | Release: None | Updated: May 14 2011 at 7:03 PM by cjt | Created: May 14 2011 at 7:03 PM by cjt

1
Vote

Config to allow CreatedBy and ModifiedBy columns to be INT

I generally want @StrictUserContext = 0 b/c my app has internally managed security. I like having the columns specified by @BaseTableDDL, except I'm always using an INTEGER which is a FK to a User...

Id #30350 | Release: None | Updated: Mar 15 2011 at 8:56 PM by bdill | Created: Mar 15 2011 at 8:56 PM by bdill

1
Vote

OldValue and NewValue are truncated

In version 2.x the Audit table is created with VARCHAR(MAX) for the OldValue and NewValue columns. The insert, update, and delete triggers use CAST or CONVERT to change the data to VARCHAR(50). I...

Id #29479 | Release: None | Updated: Nov 17 2010 at 6:38 PM by ajalexander | Created: Nov 17 2010 at 6:38 PM by ajalexander

1
Vote

Error running pAutoAudit for tables with only a primary key

In cases where there is a table with only an id column (left over as a discriminator table from a Linq-to-SQL project), pAutoAudit fails when trying to build the *_Audit_Update procedure. If the o...

Id #28890 | Release: None | Updated: Sep 15 2010 at 5:42 PM by ajalexander | Created: Sep 15 2010 at 5:42 PM by ajalexander

1
Vote

SchemaAuditDDLTrigger doesn't execute pAutoAudit

SchemaAuditDDLTrigger looks for '%StrictUserContext = 1%' in the text of the *_Audit_Insert procedure. The StrictUserContext comment is no longer in that format however. It should check for '%Str...

Id #28889 | Release: None | Updated: Sep 15 2010 at 5:36 PM by ajalexander | Created: Sep 15 2010 at 3:50 PM by ajalexander