CJSmith dot me

I dump stuff I find useful here

  • 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

  • Populate Sage table opheadm with credit note information for Cindercone Magma to send to Tungsten/OB10

    On

    09/06/2019

    By

    Chris Smith

    The below stored proc is used to populate two Sage fields shipper_code2 and shipper_code3 in the Order Header Table. Obiously […]

    Continue reading

  • Force TSQL dateformat

    On

    09/06/2019

    By

    Chris Smith

    If you get the following error on scheduled stored procedures, force the dateformat (The Microsoft SQL Server scheduler will probably […]

    Continue reading

  • Use a case to make sure provided data is a date

    On

    03/06/2019

    By

    Chris Smith

    I find this useful for using validating spreadsheet imports, using ISDATE can just blank the field if crap data is […]

    Continue reading

  • Check the audit on Business Objects XIR3 SP7 for logons

    On

    03/06/2019

    By

    Chris Smith

    This is useful to see who is using their licenses which are very expensive. I tend to check every few […]

    Continue reading

  • In VBA strip out characters which cause TSQL to fail

    On

    20/05/2019

    By

    Chris Smith

    A simple way to strip out characters which can cause TSQL Code to break. Assumes the SQL commannd is in […]

    Continue reading

  • Sage EDI IN Intermediary Email

    On

    01/05/2019

    By

    Chris Smith

    I have found users don’t always read the logs from the Adaptus EDI Module anymore in Sage Line 500. There […]

    Continue reading

  • Maintain regtrans-ms and blf files generated by Georgia UTS sessions

    On

    14/04/2019

    By

    Chris Smith

    A little script I schedule for servers using Georgia UTS. Below I use Robocopy to move files older than 3 […]

    Continue reading

1 2 3 4 5 … 8

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 ERP
  • SQL Server
  • SQL Server 2008
  • SQL Server 2008 Express
  • SQL Server 2012
  • Syncplify.me Server!
  • SyncToy 2.1
  • Uncategorized
  • 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

  • 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