CJSmith dot me

I dump stuff I find useful here

  • Rebuild a V1 DBCapture Database Queue

    On

    16/07/2017

    By

    Chris Smith

    We have an issue where on a rare occasion a scan from V1 DBScanner to DBCapture can corrupt the queue

    Continue reading

  • Updating a network location in Windows 2012

    On

    14/05/2017

    By

    Chris Smith

    I had an issue where a server which was joined to a domain had incorrectly set its network as Public.

    Continue reading

  • Filtering in Event Viewer Windows Server 2008 onwards

    On

    14/05/2017

    By

    Chris Smith

    The Event Viewer from Server 2008 onwards is XML based. Filters based on XML syntax can be used such as:

    Continue reading

  • Method of working out check digit for an SSCC code

    On

    26/03/2017

    By

    Chris Smith

    Method of working out check digit for an SSCC shipping code in SQL on a system with Sage Line 500

    Continue reading

  • Apply ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to SQL Server

    On

    05/02/2017

    By

    Chris Smith

    We needed to enable ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to specific databases on a SQL Server 2008 instance, I found to do

    Continue reading

  • Add a user to DatabaseMailUserRole on msdb

    On

    05/02/2017

    By

    Chris Smith

    I had a user unable to use a script which generated an email, I found the user didn’t have permission,

    Continue reading

  • Simple error checking when running batch files from T-SQL in SQL Server

    On

    14/01/2017

    By

    Chris Smith

    A while ago we added error trapping to the batch file called by a SQL script, this was to ensure

    Continue reading

  • Microsoft Access 2010 loader

    On

    08/01/2017

    By

    Chris Smith

    Credits (As what I consider the hard stuff was actually done by other people): TheSmileyCoder for the solid awesome little

    Continue reading

  • Why use ACCDE and then ACCDR Access Front Ends

    On

    08/01/2017

    By

    Chris Smith

    Nearly every single Microsoft Access “database” I use has a proper database attached instead of using the internal Jet Engine,

    Continue reading

  • Within a batch file run a program for a certain length of time before killing it

    On

    08/01/2017

    By

    Chris Smith

    I needed to run a scheduled batch job and kill it off after a certain amount of time, this was

    Continue reading

1 … 5 6 7 8 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