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