Category: Windows
Check scheme.plitempm for any orphaned entries
Check scheme.plitempm for any orphaned entries against plpy tables, found to be caused by third party app not Sage Line […]
Batch file set year into the future
Simple batch to set a variable 2 years into the future, works out Year, plus 2 and then adds to […]
Restart Windows Server Task Scheduler
Requires PSExec to use the interactive account psexec -i -s cmd sc stop schedule sc start schedule Credits: StackOverflow
V1 DBAuthorise grab a list of Purchase Orders
V1 DBAuthorise can be setup to have multiple Purchase orders, so I use a Common Table Expression in a view […]
Maximum History Reached in Code & Post Registered Invoices
Credit: Datel Code & Post Registered Invoices has a database limit on the plreghstm table and can hold 79 rows […]
Prevent Duplicate Audit Entry warnings on Sage Line 500 when migrating systems
The file .seqno in csmaster/master is used to maintain the current audit reference. Ensure its copied from the old server […]
Microsoft Message Queuing Service – Correct Permission Issue
Credit: Aggregated Intelligence We had a request after software was installed to give permissions to a group in Windows AD. […]
Sage Line 500 password policy implementation and force password reset
I wrote a simple script to aid users moving to a new password policy, users were put on a policy […]
Test Pop3
Pop3 can be tested via Command line using the telnet executable (Will need to be selected from Windows features). Telnet […]
My Windows 10 Desktop Settings
I hate the default Windows settings, I normally run the following to customise the profile to my liking (I don’t […]