Category: SQL Server
Sage Line 500/1000 Period End Email Check
As part of Sage Line 500/1000 Period End we found it easier and more audit friendly to have an automated […]
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 […]
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 […]
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 […]
Setup MS SQL Server Alerts via TSQL
Amend TSQL to your environment, run the TSQL, restart the agent service and test (I find it easy to enter […]
Tidy Sage Line 500 ERP Temporary Tables via TSQL
The official Sage Help has a select statement to delete temporary tables, but doesn’t allow an automated way to remove. […]
Powershell issue with output characters changing to ?
On PowerShell command pipe to export CSV add Encoding Unicode if characters change to ? Credit: Idera execute xp_cmdshell ‘powershell […]
Mail on Login failure to a Microsoft SQL Server
Ensure a mail profile is setup and make a note of its name. Run the following in Microsoft Query Analyser […]
Populate Sage table opheadm with credit note information for Cindercone Magma to send to Tungsten/OB10
The below stored proc is used to populate two Sage fields shipper_code2 and shipper_code3 in the Order Header Table. Obiously […]