Sage Line 500 User Activity Data
Sage Line 500 ERP maintains user activity data in: DATABASE_SERVER.csmaster.scheme.uar
Tidy Sage Line 500 ERP Temporary Tables via TSQL
The official Sage Help has a select statement to delete temporary tables, but doesn’t allow an automated way to remove. […]
Avoid error “2427 You entered an expression that has no value” when passing a parameter to a form
To avoid getting an error when passing a variable to a form, using If Not against the EOF (I believe […]
Arcsoft Totalmedia Extreme causing issues upgrading to Windows 10 Version 1909
I recently had fun with being unable to upgrade to version 1909 for Window 10 failing with a BSOD and […]
Powershell issue with output characters changing to ?
On PowerShell command pipe to export CSV add Encoding Unicode if characters change to ? Credit: Idera execute xp_cmdshell ‘powershell […]
Windows 2008 – Alert on Scheduled Job Failure
First we need to enable logging for the Windows Task Scheduler, open Event Viewer (Put “eventvwr.msc” in Run) and browse […]
Mail on Login failure to a Microsoft SQL Server
Ensure a mail profile is setup and make a note of its name. Run the following in Microsoft Query Analyser […]
Sage Line 500 V7.1 CSAgent TCR and Form appear to start but ports never open
Recently we had this issue where after windows patches were applied, after a reboot the Sage Line 500 v7.1 Windows […]
Populate Sage table opheadm with credit note information for Cindercone Magma to send to Tungsten/OB10
The below stored proc is used to populate two Sage fields shipper_code2 and shipper_code3 in the Order Header Table. Obiously […]
Force TSQL dateformat
If you get the following error on scheduled stored procedures, force the dateformat (The Microsoft SQL Server scheduler will probably […]