Remove invalid Datalinx WHM Report Records
Where printers have been removed can cause issues with the user report program where you can control where users print […]
Setup MS SQL Server Alerts via TSQL
Amend TSQL to your environment, run the TSQL, restart the agent service and test (I find it easy to enter […]
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 […]