AutoAudit was originally published on CodePlex. That site is now archived, but we never know for how long it will last. I want to preserve the code and documentation here. This is the source of something I blogged about in 2015, AutoAudit – sql audit trail tool AutoAudit.zip – Archive of Original Code from CodePlex […]
AutoAudit by default will add 5 columns to your table, when you turn it on for a table with this command: EXEC [Audit].[pAutoAudit] @TableName='SEOConfig', @BaseTableDDL=1; Those columns are: AutoAudit_CreatedDate, AutoAudit_CreatedBy, AutoAudit_ModifiedDate, AutoAudit_ModifiedBy, and AutoAudit_RowVersion. However, you often have your own columns for the first four: CreatedDate, CreatedBy, ModifiedDate, and ModifiedBy, and you can tell AutoAudit […]
Sometimes with testing (especially with BizTalk), you need to copy or move some or all files in one folder to another, or all files after a given date. But, you want to space out the copy/move of the files, and that’s what I mean by “dripping” them. You want the files to drip in for […]
Sometimes, you just want to know what programs or source code was most recently changed. The excludes below were set up to work with BizTalk source directories. I was only wanting to see files changed by a person, so change the -Exclude list as needed. cls $sourceCodeDirectory = "D:\Source" $numberOfFilesToRetrieve = 50 $latestFiles = (Get-ChildItem […]
Running a BizTalk MSI, on a second BizTalk server, gave this error: There is a problem with this Windows Installer. A program run as oart of the setup did not finish as expected. Contact your support personnel or package vendor. I checked the Windows Application Event Log and found the 1603 number. In my case, […]
This PowerShell script finds two files last-updated (or created) within x seconds of each other. You can specify the max difference in time with the variable “$maxDifferenceInSeconds”. With a few changes you could make this program work with minutes, hours or days. In our scenarios, we receive files from a vendor or another application. Sometimes, […]
We were receiving some files of data that was not sorted, and needed to be able to do a side-by-side compare of two files. Two files could have the same data values, but might not be in the same order. Without the data being sorted, the compare was basically impossible. cls # # Author: Neal […]
I’m adding to my collection of SQL queries that run against the BizTalk database. The first query below goes from Orchestration to Send Port. If the orchestration uses Direct Binding, it will have a logical Orchestration PortName, but no bindings to a SendPort. The second query goes from SendPort to Orchestration. I’d love to show […]
Here are some samples that might be useful if you need to dynamically send a REST “POST” message. Of course, in the real world, the token and the URL would probably be some type of configuration variable. YourMsgRequestName(WCF.HttpHeaders) = "Accept: application/json" + "\r\n" + "Content-Type: application/json " + "\r\n" + "X-AUTH-TOKEN: yourSecretAuthTokenHere" ; // Add […]
Error When you try to manually set the SQL password on a WCF SQL port in a binding file, you might get tthis error: Error Description: System.ArgumentNulLException: Value cannot be null. Parameter Name: Password Solution The scenario is typically that you export a binding file from BizTalk. The exported file will never contain the actual […]