Upgrade Gotcha: Media Objects
I got a great reminder from a post today on Shannon's JDE CNC Technical Blog titled "Media Objects Gotcha-upgrade / deployment server name". During an...
How To Compare Field Values Between Tables
I used the following SQL to compare the difference between the F9200 (Data Dictionary) used for EnterpriseOne 9.1 and the one used for EnterpriseOne 8.12...
SQL Server Error: Cannot resolve the collation conflict between "Latin1_General_CI_AS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
I received the following error when trying to join an EnterpriseOne 9.1 table with an EnterpriseOne 8.12 table that was copied to the SQL Server...
How To Change The Schema Of All Tables In A SQL Server Database
Below is the SQL that can be used to change the database schema of all tables in an SQL Server Database. We use it when...
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...