How To Drop All Tables In An SQL Server Database
I've been doing a lot of work with SQL Server lately and have found the following SQL that can be used to drop (delete) all...
Great iSeries SQL Reference When Working With Dates & Times
I really used this page a lot when working with SQL and dates & times. DB2 Basics: Fun With Dates and Times
End Subsystem Jobs Using SQL
We have noticed many orphaned subsystem jobs piling up in the F986113. In tracking them down we found that the way we stop the subsystem...
EnterpriseOne SubSystem Jobs Not Starting
For a while now we have had an issue where our subsystem Purchase Order Print job (R43500) will not run in JPD900 but it will...
How To Turn Off the Windows Firewall Using A Command Line Script
In order to get EnterpriseOne to play nicely on Windows Servers and Workstations, we need to disable the Windows Firewall on several ports. I don't...