Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: edgare
  • Order by date
  1. edgare

    New Report inside the Macola Menu

    i am using crystal 8.5 standard edition. I dont have the "report compiler" people are talking about if you know how i can get it or is it just for dev edition? I just want teh report basically its check register after date is specified automatically export the report to a text file. We are...
  2. edgare

    New Report inside the Macola Menu

    Ok i created a custom crystal report we are using macola 7.6.300b and i have the rpt file. How do i integrate it into the menu like AP right after check history under reports. I know i can create a shortcut but thats not what i want to do....
  3. edgare

    macmsl.dll error

    Thanks i will try that here is the text of error i had but I think your reg fix should fix it. Thanks again. MSL Technical Error Info: An error occured in MacMSL.dll (ver. 76.300.10.5) DB Provider Error: Native Error number: 0 Error number: 0x80004005 Timeout expired COM Error: Error Code =...
  4. edgare

    sql server 7 desktop ed

    i have a database for a company running on sql srv 7. There are two databases over 1 gig each. They work fine but on reports it takes forever to generate. I do see 40 to 100 locks on database but not much is happening on there while its running the reports. I know that there is a limit set...
  5. edgare

    sql 7 desktop edition

    ok i got sql 7 desktop edition running with Macola 7.6.300b its about 1 gig in size. Some of the reports run really slow. Is there a way to speed up desktop edition? i know there are limits ... other then upgrading what can i do? I got 3 gigs of ram and raid 5 ....
  6. edgare

    sql msde database size limit

    It is actually a development enviroment ... Another quick question does the "personal edition" of sql come bundled with std or ent? or is it separate cd??
  7. edgare

    sql 7 msde question

    cool but what would happen if the msde goes over 2 gig would the server stop processing any new requests? since its the limit ...
  8. edgare

    sql msde database size limit

    I had a few questins: what happens if database exeeds 2 gigs on sql server 7 msde? (is there a 2 gig limit on sql server 7 pe? and would msde upgrade to pe ? ) Is there a way to upgrade from sql 7 msde to sql server 2k developer? (on a 2k pro machine) After upgrade can the clients still...
  9. edgare

    slow switching between screens

    just switching between screens was really slow like actually opeing up lets say Customer screen in ar or ap. What i did was to reboot the Macola server and do offline reindex of database its flying now!
  10. edgare

    slow switching between screens

    we got macola 7.6spb running sql and its very slow switching between screens like ap to ar or opening something up withing each of those modules. Once it opens up its fast ... like reports run fast its just switching between screens is very slow.
  11. edgare

    printing boxes

    ok i got a field its a string ... I need to create a text box that will print lets say one * if the contents contains 10 and ** if contents contains 7.5. The string has alot of alphanumerical data sometimes not just the 10 and 7.5... How do I do this? I am using 8.5. Thanks
  12. edgare

    Converting and Publishing to Web

    Is there a way to convert report saved in v11 back to version 8.5?? Also cani publish Reports on the web with ability for users to input parameter w/o the C.R. Server ?
  13. edgare

    Speeding things up

    Would scripts like this help? Or its pointless just using tuning is a better way ? (which by the way didnt work on my database its named DATA_10 sorry not much knowledge in programming) /* Defrag or re-index all indecies */ DECLARE @TableName sysname DECLARE @IndexName VARCHAR(100) DECLARE...
  14. edgare

    Speeding things up

    Would the Maintanance wizard fully rebuild and reindex the tables?? Or r u talkin abou the Index Tuning Wizard?
  15. edgare

    Speeding things up

    Hi whats the best way to reindex,defrag and rebuild the database to increase performance? I am using SQL 7.
  16. edgare

    sql server reindex script issue

    Hi guys I found this script on the net to reindex and defrag my databases... doesn’t seem to work ... I am not a programmer so any help would be appreciated. Also is there a way to rebuild them or does this do that to? /* Defrag or re-index all indecies */ DECLARE @TableName sysname DECLARE...
  17. edgare

    Optimizing SQL Database

    hey can someone finetune this sql code to work with macola :) Sorry its rather long.... /* Defrag or re-index all indecies */ DECLARE @TableName sysname DECLARE @IndexName VARCHAR(100) DECLARE @indid int DECLARE cur_tblfetch CURSOR FOR SELECT name from sysobjects where xtype='U' OPEN...
  18. edgare

    Optimizing SQL Database

    Thanks couldnt find ur email on here but you can email me edgare@impress1.com. Thanks
  19. edgare

    Optimizing SQL Database

    Anyone have experience in optimizing the database? Would you just use the tools in SQL maintenance to resize freespace ... reindex ... or have you guys tried something more? I came across a vendor http://www.quickshift.com they claim to at least double the speed. I am going to try this and will...
  20. edgare

    SQL Server Memory leak

    How about memory and database size ... how are they related ? I got 2 gigs of ram and 2 databases running one is about 1 gig and other one is about 2 ... will this also impact it?

Part and Inventory Search

Back
Top