Credit Cards Slow Down Processing

Jun 10, 2007 4 Replies

I need to go in and reset both Server and Internet Server weekly because after about 7 days, credit and debit cards slow down to a crawl.



Wondering, can I delete old batches from credit cards...taking up space and probably slowing me down. Please pass on the SQL statement to do this.



One more question, as the 2GB limit gets reached using MSDE Server, what happens? Not sure whether I want to upgrade to SQL Server 2007 (or whatever) or upgrade to RMS 2.0...Any suggestions or preferences from Microsoft?


Upgrade to SQL 2005 express, it replaces MSDE and has a 4gig limit. You must have RMS 1.3R or higher installed to take advantage of this.

Hello Roxanne, Do you still have the Cost update trigger that Rob gave you sent you a while back?

Victor

"Roxanne" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required