RE: [Emerald] Another SQL question

New Message Reply Date view Thread view Subject view Author view
Tony Devlin (
Fri, 9 May 2003 15:06:10 -0400

From: "Tony Devlin" <>
Subject: RE: [Emerald] Another SQL question
Date: Fri, 9 May 2003 15:06:10 -0400
Message-ID: <>

Hehe, Don't you just hate "probably" answers. They don't give you that warm fuzzy feeling we'd all like. =)

I also have the same problem with the report printing and displaying. And sometimes I'll attempt to do a report and get some generic one of ?! .. Anyhow there are apparent problems and I have attempted the last 6 months to track them down with no avail. I have cleared up many memory leaks and other problematic queries, but none that have solved the question at hand.

Essentially I don't have to reboot, I merely shutdown the EmeraldWeb Service and Restart it. So I know the problem exists somewhere in there.

If any answers are found please post them as I would greatly appreciate being able to fix this problem.

--Tony D.

-----Original Message----- From:
[]On Behalf Of Dale E. Reed Jr. Sent: Friday, May 09, 2003 2:54 PM To: Subject: RE: [Emerald] Another SQL question

> Also, I walked through the indexing wizard on our system last night
> (sql2000), and it stated that we would achieve a 67% increase in
> performance
> if we ran it. Is this something that I should / could do without
> anything? Or will this adversly interfere with Emerald operations?

Adding an index (non-contraint/unique) probably will not affect Emerald.



This is a user supported list. If you require assistance from IEA Software's Support Engineers, please check out our Support resources at

For more information about this list (including removal) go to:

New Message Reply Date view Thread view Subject view Author view
This archive was generated on Fri May 09 2003 - 11:47:54 Pacific Daylight Time