Deleting user who owns objects in SQL

Submitted by 334 on
Symptom
When you delete a user in Millennium, if that user owns objects in SQL, the objects must be transferred to another user.  When you delete the user in Tools>System Upkeep>User Security>User Maintenance, if the user owns objects in SQL there will be a message that the owned objects must be transferred to another user.  There is a dropdown of users presented once Delete is clicked but not all of the users are listed in the dropdown.
Product Line

"Utility Error" running Years utility

Submitted by 334 on
Symptom
The years utility is being run by the 'sa' account. The utility runs for a few minutes and then the queue displays "Utility error".
The error in createyearsout.log file in the queue folder displays the following error:

"Error Encountered when dropping temporary table.  Above error message MAY contain further ODBC and/or other error details."
Product Line