I did as you said below and got the following results:
"This command did not return data, and it did not return any rows"
I went into Emerald and tried to consolidate and got the eror executing
message again. So I went back into isql_w and ran the console.sql script
again. This time I got this result:
"Msg 2729, Level 16, State 1
Object 'Consolidation' group number 1 already exists in the database.
Choose another procedure name
Msg 2729, Level 16, State 1
Object 'DeleteCalls' group number 1 already exists in the database.
Choose another procedure name"
I went back into Emerald again and tried to run the consolidation and this
time it seem to work ok. It said it ran successfully. However, I don't
understand the above results from running the script and if they have any
implications to my situation that I should be concern about.
At 10:57 AM 7/1/98 -0700, Dale Reed wrote:
>Alan D. Criado wrote:
>> We are trying to run the consolidation but every time we try, we get the
>> following error message:
>> Error executing Consolidation Proceedure!
>> As you can see the error message is not very descriptive, so I don't know
>> what is going wrong. Perhaps someone here knows the answer from past
>> experience and can give me a hand.
>Run the consol.sql script (in /emerald/beta) against your database
>using isql_w. Then you should be able to login as sa (unless you
>set permissions for others to execute the consolidation/deletecalls
>procs) and run a consolidation.
>Dale E. Reed Jr. (firstname.lastname@example.org)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com