|
|
1-10 of 19
< Previous Next >
|
When testing this out on my database I kept running into an issue with SchemaAuditDDLTrigger db trigger. I noticed it was trying to insert values when I made changes but was failing because "null ...
id# 21669 | Planned Release: None | Last Updated: Mar 17 at 8:54 AM by jeffcj | Created On: Mar 17 at 8:54 AM by jeffcj
The error we saw was changing a NULL decimal(9, 8) column to 0.3343 or something - the error was regarding trying to convert string to numeric - presumably for the compare. This is because the ISN...
id# 21085 | Planned Release: None | Last Updated: Feb 10 at 9:16 PM by caderoux | Created On: Feb 10 at 9:16 PM by caderoux
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...
id# 20980 | Planned Release: None | Last Updated: Feb 3 at 2:14 PM by Pol | Created On: Feb 3 at 2:06 PM by Pol
I was getting the following error:
Msg 50000, Level 16, State 1, Procedure Product_Audit_Update, Line 460
error in [dbo].[Product_audit_update] trigger
Msg 3616, Level 16, State 1, Pro...
id# 19365 | Planned Release: None | Last Updated: Feb 10 at 10:04 PM by caderoux | Created On: Nov 6 2008 at 7:55 PM by sotis71
Errors are created when a table or column has special chars in it, such as spaces in column names or $ in a table name
id# 18941 | Planned Release: None | Last Updated: Oct 14 2008 at 8:16 PM by Jwk | Created On: Oct 14 2008 at 8:16 PM by Jwk
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:...
id# 18842 | Planned Release: AutoAudit 1.09 | Last Updated: Oct 14 2008 at 12:21 AM by PaulNielsenSQL | Created On: Oct 8 2008 at 8:49 AM by Joffies
The request is to modify the audit table and all views/procs to split the audit table. Today's audits would go into the audit table, older audits would be archived into an auditarchive table. The a...
id# 17835 | Planned Release: None | Last Updated: Aug 14 2008 at 5:14 PM by pjackman | Created On: Aug 13 2008 at 9:37 PM by PaulNielsenSQL
The request is to modify the audit table and all procs to allow for uniqueidentifiers as primary keys
id# 17834 | Planned Release: None | Last Updated: Jan 29 at 8:25 PM by renegrin | Created On: Aug 13 2008 at 9:24 PM by PaulNielsenSQL
The request is to modify the audit table and all procs to allow for auditing of tables with composite primary keys
id# 17833 | Planned Release: None | Last Updated: Feb 10 at 9:17 PM by caderoux | Created On: Aug 13 2008 at 9:24 PM by PaulNielsenSQL
|
|
1-10 of 19
< Previous 1 2 Next >
|
|
|
|