Millennium

No results are returned when searching for %40716% in the Chart of Accounts-Account Number field when an exact match exists in the data.  In a SQL trace there is a difference in the select statement when searching for %40.

SELECT * FROM chart_of_accounts WHERE UPPER(chart_acct) like UPPER('%8%%') ORDER BY UPPER(chart_acct)
SELECT * FROM chart_of_accounts WHERE UPPER(chart_acct) like UPPER('@716%%') ORDER BY UPPER(chart_code)

The Update/Archive option is not available on the hover menu for a newly inserted phone number.  The phone number is not linked to an address.

Multiple runrepor.exe are displaying in task manager and the server is at max memory usage while users are working in Millennium and running reports.
There may be an error from SQL server that displays : 1455: The paging file is too small for this operation to complete.
 

Report returns 0 records if the data values have  highlighted and Add was pressed before the dropdown list of field values has disappeared.

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.

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."

When running Advanced Search there is an error at the bottom left of the screen that indicates "Error generating temporary filename".
The Advanced Search is not working for any user nor the 'sa' account.  Advanced Search was working previously.

The Add Quid Pro Quo item is greyed out on the Transaction menu for existing Sustainer Pledge transactions.

Is there a way to assign restrictions to users' accounts on individual attachments?