I'm trying to run my cosolidation for billing purposes and it's erroring out.
I click on SUMMARY and it seems to work (it creates two summaries), but
when I click on CHARGES it looks like it's trying to work, but then fails
witht he following error:
"Error executing consolidation proceedure!"
So I go into ISQL_W, select the Emerald database and run: CONSOLIDATION 1
and I get the following results:
"Msg 1205, Level 13, State 2
Your server command (process id 15) was deadlocked with another process and
has been chosen as deadlock victim. Re-run your command"
Does anyone know what's going on and how to fix it?
Thank you for your help.
Sincerely, Alan D. Criado