LOL... I agree. SQL server is one of the MS products I do like, which is not that many to begin with.
We were going to jump from access to oracle. The price tag made us change our minds. At 05:01 PM 5/29/2002 -0400, you wrote: >hehe: > > >I can sleep at nights with worry. > >Yeah I feel that way when I see MS on the cover too :) J/K I love SQL >Server, wouldn't know what to do without it. > >Tim Heald >ACP/CCFD :) >Application Development >www.schoollink.net > > > -----Original Message----- > > From: Jacob [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 29, 2002 4:57 PM > > To: CF-Talk > > Subject: Re: Memory problems > > > > > > I agree. We had Access for our database and had nothing but > > problems with > > memory leaks. Had to reset the cold fusion service at least 4 to > > 6 times a > > day. > > > > Moved to SQL 7.0. What a different. Less headaches and resets. > > Went from > > 6 resets a day to maybe one every other week. Now with Windows > > 2000, CF 5, > > and SQL 2000. I can sleep at nights with worry. > > > > Sometime it is so quiet that I have to go to the server just to make sure > > it is still going. And it is. > > > > At 02:42 PM 5/29/2002 -0400, you wrote: > > >So, the consensus is Access is the problem! I wonder if the > > memory problems > > >have gotten worse in the past couple of months because of the > > growing size > > >of the database? > > > > > > > I think in the cfusion\bin directory there is a batch file > > provided that > > > > sets up your scheduler to restart cf services at 2am (or so). > > > > > >So running Cycle.bat sets up the scheduler? Or do I need to schedule > > >Cycle.bat to be run? > > > > > >I guess conversion to MySQL is now on the top of the pile after vacation. > > > > > > -- Owen > > > > > >---- > > > > We've been having problems lately with our server running out > > of memory. > > > > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

