Use TSQL to extract V1 DBArchive Blobs
Using TSQL it is very easy to automate extraction from Version One’s DBArchive product with its dbremoteblob program (It does […]
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 […]
Simple method to see what AD Users SQL Server can see in AD Groups
Credit: Microsoft StackOverflow user Saranya Kumaran Simple method to see what AD Users SQL Server can see in AD Groups […]
Powershell script to manage V1 dbadeposit issues in pull config
Credits: Superuser Microsoft Docs V1 dbadeposit can exit and stop working when in a pull configuration (Normally V1 dbadeposit is […]
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. […]