CJSmith dot me

I dump stuff I find useful here

  • Remove invalid Datalinx WHM Report Records

    On

    28/06/2020

    By

    Chris Smith

    Where printers have been removed can cause issues with the user report program where you can control where users print […]

    Continue reading

  • Setup MS SQL Server Alerts via TSQL

    On

    08/05/2020

    By

    Chris Smith

    Amend TSQL to your environment, run the TSQL, restart the agent service and test (I find it easy to enter […]

    Continue reading

  • Sage Line 500 User Activity Data

    On

    08/05/2020

    By

    Chris Smith

    Sage Line 500 ERP maintains user activity data in: DATABASE_SERVER.csmaster.scheme.uar

    Continue reading

  • Tidy Sage Line 500 ERP Temporary Tables via TSQL

    On

    16/02/2020

    By

    Chris Smith

    The official Sage Help has a select statement to delete temporary tables, but doesn’t allow an automated way to remove. […]

    Continue reading

  • Avoid error “2427 You entered an expression that has no value” when passing a parameter to a form

    On

    16/02/2020

    By

    Chris Smith

    To avoid getting an error when passing a variable to a form, using If Not against the EOF (I believe […]

    Continue reading

  • Arcsoft Totalmedia Extreme causing issues upgrading to Windows 10 Version 1909

    On

    29/12/2019

    By

    Chris Smith

    I recently had fun with being unable to upgrade to version 1909 for Window 10 failing with a BSOD and […]

    Continue reading

  • Powershell issue with output characters changing to ?

    On

    29/09/2019

    By

    Chris Smith

    On PowerShell command pipe to export CSV add Encoding Unicode if characters change to ? Credit: Idera execute xp_cmdshell ‘powershell […]

    Continue reading

  • Windows 2008 – Alert on Scheduled Job Failure

    On

    11/08/2019

    By

    Chris Smith

    First we need to enable logging for the Windows Task Scheduler, open Event Viewer (Put “eventvwr.msc” in Run) and browse […]

    Continue reading

  • Mail on Login failure to a Microsoft SQL Server

    On

    11/08/2019

    By

    Chris Smith

    Ensure a mail profile is setup and make a note of its name. Run the following in Microsoft Query Analyser […]

    Continue reading

  • Sage Line 500 V7.1 CSAgent TCR and Form appear to start but ports never open

    On

    20/07/2019

    By

    Chris Smith

    Recently we had this issue where after windows patches were applied, after a reboot the Sage Line 500 v7.1 Windows […]

    Continue reading

1 2 3 4 5 … 9

Categories

  • Access 2010
  • Batch File Scripting
  • Business Objects
  • Cindercone Magma
  • Cisco Unity Communications
  • Datalinx WHM
  • FolderMill
  • Georgia Universal Terminal Server
  • IBM Domino 8.0
  • IBM Notes 8.0
  • Lotus Domino 6.0
  • Microsoft Office
  • Old Stuff
  • Outlook 2010
  • Sage Line 500/1000 ERP
  • SQL Server
  • SQL Server 2008
  • SQL Server 2008 Express
  • SQL Server 2012
  • Syncplify.me Server!
  • SyncToy 2.1
  • V1 DBForms
  • V1 Document Management
  • Visual Basic for Applications
  • Windows
  • Windows 10
  • Windows 7
  • Windows Server 2008
  • Windows Server 2012
  • Windows Server 2016
  • Word Press

Archives

  • October 2023
  • September 2023
  • August 2023
  • February 2023
  • June 2022
  • April 2022
  • August 2021
  • February 2021
  • January 2021
  • November 2020
  • October 2020
  • August 2020
  • June 2020
  • May 2020
  • February 2020
  • December 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • February 2019
  • January 2019
  • December 2018
  • October 2018
  • September 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • August 2017
  • July 2017
  • May 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016

CJSmith dot me


This site utilises the Charta block theme.


© 2022 CJSmith dot me