Search results for query: *

I've noticed in some of the Macola ES docs when copying a company to create a new test company in a SQL 2000 environment, they typically tell you to do a detach, copy and attach. I would normally just create a blank ES company, do a SQL backup of the original database to bak file and Restore...

Anyone have any thoughts on how to approach this? Sales manager wants a report summarizing sales by quarter and/or year. Would like to be able to do everything - run for 1 quarter or range of quarters or likewise for years or combination of years and quarters. This is all working off of...

Have a Macola ES question. If I want to create a new test company by copying my production company to a new company, ES still shows the original company number in the screen headers within ES? It shows the correct company when entering ES, but once I'm in it still shows the old company. I...

Exported a spreadsheet out of access. Now am trying to sort data. For some reason will sort PM-LA PM-LB PML-1 PM-N Almost like it is ignoring the -. I would think it would do all the PM- together????

Have an OKIDATA 591 that prints our Order Acknowledgement and Invoice forms in a Progression 400a environment. We upgraded to a new Macola server in addition to upgrading to 400a from 300c. In addition to all this we upgraded a separate server from 2000 server to Windows 2003 Server. This...

I have a pivot table which is used for sales analysis. My data table has multiple lines associated with an order. My pivot table summarizes the lines (captures the main line and discounts associated with that). In my data section, the pivottable correctly calculates the NET USD AMOUNT, which is...

Are there any advantages to detaching/attaching a database over backup/restore if I want to move the database to another server. If I detach, I'd probably want to do a backup anyway before... Just wondering if there were any functional differences between the two...

Is there a recommended approach for a SQL Server 2000 Maintenance Plan in a Macola environment? Should I reorganize data pages? if so, what percentages? Should I check database integrity? Include indices? The Backup and Trans logs settings are pretty straight forward.. Just wondering what if...

What is the recommended setup of SQL Server on a new server? I've always thought that the Operating System, and transaction logs should go on mirrored raid set, while the actual databases should go on a raid 5 set. Is that correct? Where is the optimal place to put the SQL bak files?

What are the proper steps to modify a Progression ICR. Do you make a copy first and modify the copy? I've heard also that you must refresh the report before you make changes... Any tips?