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